January 12, 2006 at 10:14 am
Hi Guru,
One of my SQL 2000 box(marketing) has login named reportUser. This reportUser has sysadmin rights in the marketing server. There is a database named marketingRpt which maps this login to dbo. The reportUser is a valid login in syslogins table.
How can I remove this alias?
EXEC sp_dropalias 'reportUser'
Server: Msg 15134, Level 16, State 1, Procedure sp_dropalias, Line 51
No alias exists for the specified user.
Please help,
Thanks,
Silaphet,
January 12, 2006 at 4:57 pm
Are you running sp_dropalias in the MarketingRpt database?
Perhaps the login isn't aliased to dbo at all. If the login is a member of sysadmins, it's not aliased to dbo in the database but any objects created by the login belong to dbo (see DBO in BookonLine).
Greg
Greg
January 13, 2006 at 10:17 am
Use the Enterprise Manager to fix this problem, in the "Security->Logins" tab for the server. As a general rule, your users should not have "sysadmin" rights, unless they really are a system administrator. Create the user with no rights, and give them permissions to each stored proc used by your reporting application.
Good luck!
Jasmine
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply