sutanu_halder

 Profile Answers by sutanu_halder 

• Dec 14th, 2007

 

There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.

Such as:- 1. ANALYZE ANY
                2. CREATE CLUSTER
                3. CREATE ANY CLUSTER
                4. ALTER ANY CLUSTER
                5. DROP ANY CLUSTER
                6. ALTER DATABASE
                7. CREATE ANY INDEX
                8. ALTER ANY INDEX
                9. DROP ANY INDEX
               10. GRANT ANY PRIVILEGE
               11. CREATE PROCEDURE
               12. CREATE ANY PROCEDURE
               13. ALTER ANY PROCEDURE
               14. DROP ANY PROCEDURE
               15. EXECUTE ANY PROCEDURE
               16. CREATE TABLE
               17. CREATE ANY TABLE
               18. ALTER ANY TABLE  
               19. BACKUP ANY TABLE
               20. DROP ANY TABLE
               21. LOCK ANY TABLE
               22. COMMENT ANY TABLE
               23. SELECT ANY TABLE
               24. INSERT ANY TABLE
               25. UPDATE ANY TABLE
               26. DELETE ANY TABLE
               etc....................

Granting,revoking of privilages is possible but adding new privileges or deleting existing privileges is not possible.