October 24, 2008 at 11:06 am
Hi...........
How do I create a user or user group, grant him permission to execute only views, stored procedures and select statements but not add/update/delete data or tables directly? Can anyone give me a sample script?
Thanks in advance.....
Sanya
October 24, 2008 at 12:30 pm
The easy way to do this is through Schemas: Put the tables in one schema (DAT) and everything else in another schema (EXE) that has access rights to DAT.
Then give the users normal access to EXE, but no access to DAT.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply