users do not appear in sys.sysusers

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 2005 Forums

SQL Server Administration (2005)

users do not appear in sys.sysusers

Author

Topic

laailalalaa
Yak Posting Veteran

57 Posts

Posted - 2009-03-02 : 07:29:38

as an sa i wrote a script that created about 100 logins and users for a previously created database as follows:

use [dbName]
grant create table, create view, create function, create procedure, create default to public
exec sp_addlogin 'username','password','dbName','us_english'
exec sp_grantdbaccess 'username'

afterwards i login as several different users and do all sorts of operations on dbName.

when i execute the following query:

select uid, name from sys.sysusers

only 3 users from the previously created ones are in the result set.

does anyone know how can i get all the users to be in sys.sysusers?

thank you

subhash chandra
Starting Member

40 Posts

Posted - 2009-03-02 : 07:50:21

Make sure you are logged in as "sa" (or a login of sysadmin role) when running the query to get the list of all logins.