ReliDB

Oracle uses Roles to define the privileges and rights a user has in an Oracle database. By defining a Role with specific system and object privileges, we greatly reduce the complexity of creating a new user account within any system. This is accomplished by assigning all specific rights to a single Role then [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, oracle 9i. Tags: create, ddl regenerate, Oracle, role, SQL. Comments: None