To assign permissions to NT users and groups that access Adaptive Server over trusted connections:
Use sp_grantlogin when Adaptive Server is running under Integrated mode or Mixed mode, and the connection is Named Pipes.
Use the grant command when Adaptive Server is running under Standard mode or Mixed mode with a connection other than Named Pipes.
The sp_grantlogin permissions can include either one or more Adaptive Server roles or just the default parameter. This parameter indicates that Adaptive Server provides the user with the default permissions as assigned by the grant command.
To use the sp_grantlogin, grant, and default parameters in an example:
To assign the System Administrator and System Security Officer roles to all members of the NT group named Administrators, enter:
sp_grantlogin "Administrators", "sa_role sso_role"
Then, to assign “select” permissions on the sales table to the NT user, “hasani”, enter:
sp_grantlogin "hasani", "default" grant select on sales to hasani
If you do not specify a role or a value with sp_grantlogin, the procedure automatically assigns the default value.