Storage Server gives you full control to define your own permission schemes, which you can assign to database users when creating them. Users are spared the overhead of writing and executing lengthy SQL queries to grant database privileges to database users.
Follow the steps below to define privilege templates.
- Log in to the management console and select Privilege Templates from RSS Manager.
- Select the environment and click Add Database Privilege Template.
Provide a name for the template and select the permissions by simply checking appropriate check boxes. For example,
The permissions are described below:
Permission Description SELECT The SELECT privilege enables you to select rows from tables in a database INSERT The INSERT privilege enables rows to be inserted into tables in a database UPDATE The
DELETE Theprivilege enables rows to be deleted from tables in a database. CREATE Theprivilege enables creation of new databases and tables. DROP Theprivilege enables you to drop (remove) existing databases, tables, and views. GRANT The GRANT privilege enables you to give privileges to a specific user or role, or to all users, to perform actions on database objects. REFERENCES The REFERENCES privilege Enables a user to create a foreign key dependency on a table or materialized view. INDEX Theprivilege enables you to create or drop (remove) indexes. ALTER Theprivilege enables use of altering the structures of available tables. CREATE_TEMP_TABLE Theprivilege enables the creation of temporary tables. LOCK_TABLES The LOCK_TABLES explicitly acquires table locks for the current client session. CREATE_VIEW Theprivilege enables the user to create a view. SHOW_VIEW Theprivilege enables the user to view the created view. CREATE_ROUTINE Theprivilege is needed to create stored routines (procedures and functions) ALTER_ROUTINE Theprivilege is needed to alter or drop stored routines (procedures and functions). EXECUTE Theprivilege is required to execute stored routines (procedures and functi EVENT Theprivilege is required to create, alter, drop, or see events for the Event Scheduler TRIGGER Theprivilege enables trigger operations.
- Click "Save" to complete.