Creating Privilege Templates

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.

1. Log in to the management console and select Privilege Templates from RSS Manager. 
   
2. Select the environment and click Add Database Privilege Template.
   

3. 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 UPDATE privilege enables rows to be updated in tables in a database.
   DELETE	The DELETE privilege enables rows to be deleted from tables in a database.
   CREATE	The CREATE privilege enables creation of new databases and tables.
   DROP	The DROP privilege 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	The INDEX privilege enables you to create or drop (remove) indexes.
   ALTER	The ALTER privilege enables use of  altering the structures of available tables.
   CREATE_TEMP_TABLE	The CREATE TEMPORARY TABLES privilege enables the creation of temporary tables.
   LOCK_TABLES	The LOCK_TABLES explicitly acquires table locks for the current client session.
   CREATE_VIEW	The CREATE VIEW privilege enables the user to create a view.
   SHOW_VIEW	The SHOW VIEW privilege enables the user to view the created view.
   CREATE_ROUTINE	The CREATE ROUTINE privilege is needed to create stored routines (procedures and functions)
   ALTER_ROUTINE	The ALTER ROUTINE privilege is needed to alter or drop stored routines (procedures and functions).
   EXECUTE	The EXECUTE privilege is required to execute stored routines (procedures and functi
   EVENT	The EVENT privilege is required to create, alter, drop, or see events for the Event Scheduler
   TRIGGER	The TRIGGER privilege enables trigger operations.

    
   

4. Click "Save" to complete.