Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of system privileges are there, Can we add or
delete privileges?
- 2 Answers
- 7741 Views
- I also Faced
- E-Mail Answers
Answer Posted / sarika jayadave
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you open a cluster administrator?
What do you mean by authentication modes in sql server?
Explain datetimeoffset data type in sal server 2008?
Explain the concepts and capabilities of sql server?
What is single-user mode?
What are out-of-range errors with date and time literals?
Explain why variables called the most powerful component of ssis?
What is onf in normalization form?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is the default fill factor value?
What is conditional split?
What is an index in sql?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to override dml statements with triggers?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
