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. In this tutorial, you use Sybase Central to perform the tasks in the tutorial.
Sybase Central caches information about the database such as what privileges and roles a user has. If you make changes to the database on another connection, Sybase Central won't see the changes until you refresh the database in Sybase Central. You can do this by selecting either the database or any object in the tree in the left panel and then pressing F5.
Lesson 1: Create two new users: User1 and User2 (Sybase Central)
Lesson 2: Grant privileges to User1 (Sybase Central)
Lesson 3: Create a role and grant it to User1 (Sybase Central)
Lesson 4: Convert User1 to a user-extended role and grant that role to User2 (Sybase Central)
Lesson 5: View the roles and privileges for User2 (Sybase Central)
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|