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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-10-10 : 05:21:01
|
| i need to build a secured applicationi have created on the SQL SERVER a user with a public and db_readeronly permmision !!!when i try to activate a STORED PROCEDURES i am denied by the server!!!(in the STORED PROCEDURES i do insert,update )the point is that i cant allow db_owner to the user beacuse in this case the user (id he break into the server) to alter tables names and so on!!!so is there a way withought giving a db_owner permmision to still allow STORED PROCEDURES activation?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-10 : 05:32:54
|
| have you granted execute permission on the user?--------------------keeping it simple... |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-10-10 : 05:43:44
|
| where do i need to give an execute permission? for each stored proceudre?thnaks againpeleg------>.after editedit :it worke thanks alot!!!Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
security problem with STORED PROCEDURES