How many types of system privileges are there, Can we add or
delete privileges?
- 2 Answers
- 6723 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 try...catch with sql server?
Can sql servers link to other servers?
What is sharding?
Explain sub-query?
What is the difference between mysql and sql server?
what are user defined datatypes and when you should go for them? : Sql server database administration
Do you know what is a with(nolock)?
What are transactions and its controls?
What is the use of custom fields in report?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is SQL Azure Data sync?
Explain raiserror in sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
