September 2010
Intermediate to advanced
1704 pages
111h 8m
English
The Object Explorer in SSMS enables you to manage permissions at many different levels of the permission hierarchy. You can manage permissions at a high level, such as the entire server, or you can manage permissions at the very lowest level, including a specific object, such as a table or stored procedure. The degree of granularity you use for permissions depends on your security needs. To demonstrate the scope of permissions, let’s look at managing permissions at several different levels, starting at a high level and working down to the object level.
There are many different ways to achieve a security goal in SSMS. For example, you can manage permissions for a database user from the database or from the ...