Default privilege categories:

  • Privileges for an database developer:
 DROP ANY RULE SET 
 DROP ANY SEQUENCE 
 DROP ANY TABLE 
 DROP ANY TRIGGER 
 DROP ANY TYPE 
 DROP ANY VIEW 
 DROP PROFILE 
 DROP ROLLBACK SEGMENT 
 DROP TABLESPACE 
 EXECUTE ANY INDEXTYPE 
 EXECUTE ANY OPERATOR 
 EXECUTE ANY PROCEDURE 
 EXECUTE ANY RULE 
 EXECUTE ANY RULE SET 
 EXECUTE ANY TYPE 
 EXPORT FULL DATABASE 
 FLASHBACK ANY TABLE 
 FORCE ANY TRANSACTION 
 FORCE TRANSACTION 
 IMPORT FULL DATABASE 
 INSERT ANY TABLE 
 LOCK ANY TABLE 
 MANAGE TABLESPACE 
 MERGE ANY VIEW 
 ON COMMIT REFRESH 
 QUERY REWRITE 
 READ ANY FILE GROUP 
 RESTRICTED SESSION 
 RESUMABLE 
 SELECT ANY TABLE 
 SELECT ANY TRANSACTION 
 UNDER ANY TABLE 
 UNDER ANY TYPE 
 UNDER ANY VIEW 
 UPDATE ANY TABLE 
 "CONNECT"
 "EXP_FULL_DATABASE"
 "IMP_FULL_DATABASE" 

Default profile categories:

  • Developer profile:
CREATE PROFILE "DEV_PROFILE" LIMIT CPU_PER_SESSION DEFAULT
CPU_PER_CALL DEFAULT   
CONNECT_TIME 2880  -- in minutes
IDLE_TIME 2880  -- in minutes
SESSIONS_PER_USER 10
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
PRIVATE_SGA DEFAULT
COMPOSITE_LIMIT DEFAULT
PASSWORD_LIFE_TIME 365 -- in days
PASSWORD_GRACE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_LOCK_TIME DEFAULT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_VERIFY_FUNCTION DEFAULT

-- RaduStoica - 04 Apr 2007

Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2007-04-04 - RaduStoica
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LHCb All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback