Thursday, March 12, 2009

Database Securables In SQL Server

Here is a list of database securables in SQL Server. 
Database Securables:
1. Alter Any Application role
2. Alter Any assembly
3. Alter Any Asymmetric Key
4. Alter Any Certificate
5. Alter Any Contract
6. Alter Any database Audit
7. Alter Any Database DDL Trigger
8. Alter Any Database Event Notification
9. Alter Any Dataspace
10. Alter Any Fulltext Catalog
11. Alter Any Message Type
12. Alter Any Remote Service Binding
13. Alter Any Role
14. Alter Any Route
15. Alter Any Schema
16. Alter Any Service
17. Alter Any Symmetric Key
18. Alter Any User
19. Alter
20. Authenticate
21. Backup Database
22. Backup Log
23. Checkpoint
24. Connect Replication
25. Connect
26. Control
27. Create Aggregate
28. Create Assembly
29. Create asymmetric key
30. Create certificate
31. Create contract
32. Create database DDL event notification
33. Create default
34. Create fulltext catalog
35. Create function
36. Create message type
37. Create procedure
38. Create queue
39. Create remote service binding
40. Create role
41. Create route
42. Create rule
43. Create schema
44. Create service
45. Create symmetric key
46. Create synonym
47. Create table
48. Create type
49. Create view
50. Create XML schema collection
51. Delete
52. Execute
53. References
54. Select
55. Show plan
56. Subscribe query notifications
57. Take ownership
58. Update
59. View database state
60. View definition

Table level
Securables:
1. Alter
2. Control
3. Delete
4. Insert
5. References
6. Select
7. Take Ownership
8. Update
9. View Change Tracking
10. View Definition

Stored Procedures level
Securables:
1. Alter
2. Control
3. Execute
4. Take Owndership
5. View Definition

Schema level
Securables:
1. Alter
2. Control
3. Delete
4. Execute
5. Insert
6. References
7. Select
8. Take ownership
9. Update
10. View change tracking
11. View definition




SQL server database. securables. database securables. database schemas. database table. database object. object level securables. Permissions. Object Security in sql server 2012. Object Security in sql server 2008. Introduction to SQL Server Security. View all securables for roles in SQL Server database. Determining User Permissions. Securables and Permissions. User or Role Properties. Overview of SQL Server Security. Permissions or Securables Page. How to Script Automatically. Permissions Hierarchy Database Engine. In sql server 2005.

0 comments:

Post a Comment