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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 User Permissions Query

Author  Topic 

vgr.raju
Yak Posting Veteran

95 Posts

Posted - 2006-12-29 : 17:17:06
HI,
I am able to login to the SQL Server.
How can I know my permission levels (ex: sysadmin,guest,reader,etc).
I used
select system_user
sp_helpuser 'current username':
This throws the following error message:
Msg 15198, Level 16, State 1, Procedure sp_helpuser, Line 189
The name supplied (*****) is not a user, role, or aliased login.
Happy New Year!

Thanks!
Raju
http://rajusqlblog.blogspot.com/
   

- Advertisement -