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.
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)
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|