Restrict access to individual table

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Yes. You can restrict aceess to individual tables with GRANT/DENY command.

anbillava Ten Centuries Points: 1146 More actions · Answer 2

Can you please give send me a piece of code which does that ?

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

Granting SELECT permission on a table

The following example grants SELECT permission to user RosaQdM on table Person.Address in the AdventureWorks database.

USE AdventureWorks;

GRANT SELECT ON OBJECT::Person.Address TO RosaQdM;

GO

Denying SELECT permission on a table

The following example denies SELECT permission to the user RosaQdM on the table Person.Address in the AdventureWorks database.

USE AdventureWorks;

DENY SELECT ON OBJECT::Person.Address TO RosaQdM;

GO

Please refere BOL for more info and examples.