How to Revoke Permissions on an Object in Microsoft SQL Server 2000
Date: Thursday, March 02 @ 06:03:44 EST
Topic: Microsoft SQL Server Online Training Demos, Tutorials


A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is

Title: How to Revoke Permissions on an Object in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of revoking permissions on an object in Microsoft SQL Server 2000. You can revoke a permission that has been granted or denied previously. Revoking is similar to denying in that both remove a granted permission at the same level. However, although revoking a permission removes a granted permission, it does not prevent the user, group, or role from inheriting a granted permission from a higher level. Therefore, if you revoke permission for a user to view a table, you do not necessarily prevent the user from viewing the table because permission to view the table was granted to a role to which he belongs.

If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.









This article comes from Labs4IT!
http://www.labs4it.com

The URL for this story is:
http://www.labs4it.com/article831.html