SQL Security Question

Last Post 03 Oct 2008 10:50 AM by phsatech. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
phsatech
New Member
New Member

--
03 Oct 2008 09:21 AM
I was wondering in SQL 2000 if a user is part of a Global goup and has say 'datareader' permission to a database, can you deny them access to specific tables or do you have to setup a role?


Appreciate input
phsatech
New Member
New Member

--
03 Oct 2008 10:50 AM
Actually found answer i.e.
DENY SELECT, INSERT, UPDATE
ON PSACCESSLOG
TO [PHSABC\PS_DBDFINDW]


Acceptable Use Policy
---