Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How do I un-grant access?

Author  Topic 

sportsguy
Starting Member

39 Posts

Posted - 2013-03-06 : 11:00:14
What's the opposite of

GRANT SELECT ON [dbo].[table_name] TO [List Name]
GO


thanks
I am being lazy!

MS Access 20 years, SQL hack

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-03-06 : 12:38:35
The true opposite would be DENY. There is also REVOKE, which is similar.
Go to Top of Page

sportsguy
Starting Member

39 Posts

Posted - 2013-03-06 : 14:54:15
Thanks!

not in the book's index, either word. . . . crappy book!

there is one sample which after many postiive examples. . .

sportsguy

MS Access 20 years, SQL hack
Go to Top of Page
   

- Advertisement -