Re: Grant v Deny


I set this as described but when the user who was in the secret list connected using ODBC and ACCESS to link the table that couldn't make any changes to the table content.

Could not use view or function because of binding errors (#4413)






"AHartman" <Hoosbruin@xxxxxxxxxxxx> wrote in message news:Y-idndyGIIBZ8cHVnZ2dnUVZ_hudnZ2d@xxxxxxxxxxxxxxx
Thanks I'll try that approach.





"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns9AC47BCEEA9CYazorman@xxxxxxxxxxxx
AHartman (Hoosbruin@xxxxxxxxxxxx) writes:
I just created 3 sensitive data tables within my database. I have a
Group that conatins multiple people and only 5 of those can have access
to these tables new tables. The rest of the people in the group need
Read access to all of the other tables within this database. These 5
people also need to be able to Read the reaming tables also.

You could put these three tables in a schema on their own. Then create
a group of the five. Then you can do:


GRANT SELECT ON SCHEMA::dbo TO AllUsers
GRANT SELECT ON SCHEMA::secretes TO GroupOfFive

AllUsers would be a role with all users in the database.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: How to protect SQL Server Express database from reverse engineerin
    ... prevent anyone from reverse engineering our database. ... I say within reasonable limits, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Copy db to webhost server
    ... host could create the database, and CDW do the rest. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Problem with my SQL 2000 Maintenance plans.
    ... I wouldn't use maint plan for this. ... using the most recent update of Books Online). ... If you do have a problem in the database, you want to be alerted so you can do ... >> option will most probably be removed in next version of SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Setting Up SQL Security
    ... want that user to have complete access to a database. ... But if it's impedient that no information whatsoever is ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: C++ Cannot find stored procedure
    ... Try Database= rather than Catalog. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)