Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges)


Tutorial: Granting roles and privileges (SQL)

In the role-based security model, users must have certain privileges or roles to run specific database operations. In this tutorial, you are a database administrator with full administrative capabilities. You want two colleagues to be responsible for debugging procedures and correcting any errors found during the debug process. You also want these same colleagues to be responsible for running backups on the company database (in this scenario, the database is the SQL Anywhere sample database). Finally, you want both colleagues to be able to update the Employees table in the database.

You must create user IDs for both colleagues and grant them the privileges and roles necessary for them to do these tasks.

 See also

Lesson 1: Create two users: UserA and UserB (SQL)
Lesson 2: Grant privileges to UserA (SQL)
Lesson 3: Create a role and grant it to UserA (SQL)
Lesson 4: Convert UserA to a user-extended role and grant that role to UserB (SQL)
Lesson 5: View the roles and privileges for UserB (SQL)