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 |
|
Tim
Starting Member
392 Posts |
 Posted - 2003-01-03 : 12:07:09
|
| is it possible to have a stored procedure that performs a task requiring sa rights, but which can be executed by a user without sa rights?any info apprec. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-03 : 12:21:08
|
| Why not just give the user the privilages to execute that sp? |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-01-03 : 12:37:54
|
| Only if the sp creator has the appropriate rights - see 'ownership chains' in BOL.Jonathan{0} |
|
|
|
|
|
|
sp permissions