Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to give select/update/delete permission to SP only
Message
From
15/06/2005 02:00:34
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
How to give select/update/delete permission to SP only
Miscellaneous
Thread ID:
01023344
Message ID:
01023344
Views:
70
Hi,

I read that one of the security way is to prevent user
all access to the database tables from select/update/delete command.

howeve, it recommend us to give permission for Stored procedures (SP)
to select those tables. How do I do it programmtically.

Any other way to improve my SQL server 2000 security


pls advise. Thank
Best Regards
Virusim
Next
Reply
Map
View

Click here to load this message in the networking platform