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
- 7754 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
Is sql server a database?
What is NOT NULL Constraint in sql server 2012?
What is an execution plan?
If a table does not have a unique index, can a cursor be opened on it?
What happens if null values are involved in comparison operations?
mention different types of relationships in the dbms?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to grant a permission in ms sql server using "grant execute" statements?
why would you use sql agent? : Sql server database administration
What are the different subsets of sql?
What is a dbms wizard?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to use subqueries with the in operators in ms sql server?
How to implement service broker?
How to create a new schema in a database?
