How to add user to database in sybase

User :

User is used to access the database and its objects

Adding Users

Adaptive Server requires a two-step process to add a user: sp_addlogin followed by sp_adduser.

to check the database user list need to enter the below command 

use <DB_NAME>

go

sp_helpuser

go

sp_adduser stored procedure is used to add the users in the database .

Here iam going to add SAPSR3 user in CL1 database .

No comments:

Post a Comment

Useful websites

https://www.yumpu.com/en/document/read/4306765/sybase-ase-15-best-practices-query-processing-optimization https://www.yumpu.com/en/document/...