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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-12-19 : 11:26:41
|
| Hi,One of the user does not have access to execute a sql stored procedure but when he run the sp it says completed successfully. SP is delete to some rows and rows are not deleted actually but in management studio it says executed successfully.SQL should say that user dont have access why it says completed even though work is not done? any ideas? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-19 : 11:44:13
|
| was he executing or was he creating sql procedure?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-12-19 : 11:47:21
|
Executing...quote:
Originally posted by visakh16
was he executing or was he creating sql procedure?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
|
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-12-19 : 12:03:21
|
| Are they executing a fully qualified (DAtabase.schema.procedure) if not are they doing it in the correct database?djj |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2013-12-19 : 12:03:55
|
| Is there another procedure, with the same name but different schema, that the user might be running instead of the one that they do not have EXECUTE permissions on?Are you 100% sure that the user does not have execute permissions on it? !! |
|
|
|
|
|
|
Stored procedure