Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

users do not appear in sys.sysusers

Status
Not open for further replies.

laailalalaa

Programmer
Mar 2, 2009
2
FR
i'm using sql server 2005

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 log in as an 'sa' and 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top