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
- 7616 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
Explain what are sparse columns?
What are the difference between primary key and unique key? : sql server database administration
What is scheduled job and how to create it?
Explain few of the new features of sql server 2008 management studio
How many joins in sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
what's the difference between delete table and truncate table commands? : Sql server database administration
What are the types of indexing?
How many tables can be joined in SQL Server?
What is the difference between clustered and a non-clustered index?
What are the lambda triggers?
What is the maximum rows in sql server table?
what is a transaction and what are acid properties? : Sql server database administration
if no size is defined while creating the database, what size will the database have? : Sql server administration
