February 5, 2004 at 1:11 pm
Any ideas? I have a user that is not showing up when i try to add permissions to a stored procedure. The dbo is "Jim" for the db, table, & sp is "Jim". When I view the permissions on a stored procedure, "JIm" does not show up.
February 6, 2004 at 4:44 am
PRobably orphaned, try running sp_change_users_login 'report'. See BOL for more on that if it returns any rows.
February 6, 2004 at 8:06 am
I ran sp_change_users_login 'Report' and it returned nothing. Any other ideas? Does it have anything to do with the fact that I"m (Jim) the dbo?
February 6, 2004 at 9:17 am
If I understand you correctly, the user dbo in the database is bound to the login jim . In that case you have to look at permissions for user dbo.
Joachim.
February 6, 2004 at 9:20 am
Check the actual values in sysusers for your uid and sysobjects for the object id, then check syspermissions. See if you already ahve permissions
It could be because you are dbo.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply