How to grant the roles to Sybase logins

Method 1:

sp_role stored procedure is used to grant the roles to sybase logins

login with system administrator and check the below command

sp_displaylogin  <login_name>

Displays information about a login account
sp_displaylogin sapsa

the above figure shows login doesn’t have any roles

Assigning role sa_role to login name sapsa by using below command
sp_role "grant", sa_role, sapsa

to check the login authorizations, use the below command
sp_displaylogin sapsa

Method 2:

grant role command is used to grant the roles to Sybase logins.
grant role sso_role to sapsa

to check the login authorizations, use the below command
sp_displaylogin sapsa