BAN_ DEFAULT_M BAN_ DEFAULT_Q

BAN_ DEFAULT_ CONNECT

The role BAN_DEFAULT_CONNECT has limited privileges. Users can connect to a database, but cannot access tables. BAN_DEFAULT_CONNECT GRANT CONNECT TO BAN_DEFAULT_CONNECT Note: SCT Banner Security discourages direct grants of any kind.

BAN_ DEFAULT_Q
The role BAN_DEFAULT_Q gives the user privileges to execute all objects and select on all tables in the database GRANT SELECT ANY TABLE TO BAN_DEFAULT_Q GRANT EXECUTE ANY OBJECT TO BAN_DEFAULT_Q

BAN_ DEFAULT_M
The role


BAN_DEFAULT_M gives the user DBA privileges to all tables and all objects in the database. The BAN_DEFAULT_M role ensures access to all appropriate tables, etc. • INSERT ANY, • UPDATE ANY, • DELETE ANY, • SELECT ANY, and • EXECUTE ANY Each role is password-protected, and each password is encrypted.




Additional delivered roles • BAN_ARSYS_REP • BAN_FINANCE_REP • BAN_STUDENT_REP

These are sample roles for reporting, which can be created for each module or as needed.