laailalalaa
Programmer
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
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