Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2002-12-28 : 13:08:15
|
| I'm planning to limit access to my base tables via SPROCs. I notice when I increase permissons on VIEWS that these permissions override more limited permissions I have set on the base tables.My question: can I give users execute permissions to SPROCs only without giving them ANY permissions to base tables, with the result being that these users will be able to accomplish any task the SPROC is scripted to do (insert, update, delete etc.) The assumption here is that SPROCs are tops in the permissions heierarchy scheme. BTW, I'm using WIN 2k server, SQL Server 7.0 sp4, database access via ODBC/Classic ASP web app with IE 5.0-6.0+ on client side, NT permissions.thxthx |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-28 : 15:06:05
|
| Assuming the table is owned by the same user as the stored procedure (by convention dbo) then yes. Have a look at ownership chains in BOL.HTHJasper Smith |
 |
|
|
|
|
|
permissions heierarchy: SPROCs rule?