Assigning trusted connection permissions

To assign permissions to NT users and groups that access Adaptive Server over trusted connections:

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:

  1. 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"
  2. 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

NoteIf you do not specify a role or a value with sp_grantlogin, the procedure automatically assigns the default value.