How many types of system privileges are there, Can we add or
delete privileges?
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 many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is ms sql server index?
What is collation sensitivity? Explain different types.
What does the update command do?
How do triggers work?
What is a select query statement in ms sql server?
What is meant by datasource?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How ssrs maintain security?
What is the difference between a clustered index and a non-clustered index?
what are the different types of SSRS reports?
What is a cube? : sql server analysis services, ssas
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How does Report Builder support Analysis Services cubes?
Explain trigger and its types?