I am using TSQL to create a 'LOGIN'

[jalbao]

I am using TSQL to create a 'LOGIN' and a 'USER' via

EXEC sp_addlogin 'foo', 'boo', 'loo'
EXEC sp_adduser 'foo', 'foo', 'db_owner';

The sp_addlogin works fine - meaning that when i use Enterprise Manager to view the LOGINS, I can see the new login that was created by my TSQL.

As far as the sp_grantdbaccess is concerned, the TSQL is not adding the USER account - meaning that when I use Enterprise Manager to view the USERS of a specific database, the user account does not appear.

During/After I run the TSQL statement I receive no errors - which makes it difficult for me to figure out why the USER account is not being added.

thanks

 

[jalbao]

i figured out my problem - a reply to this post is not necessary.

 

[tlbroadbent]

Make sure you are in the proper databse when you execute sp_adduser.

EXEC sp_addlogin 'foo', 'boo', 'loo'
Use mydatabase
Go
EXEC sp_adduser 'foo', 'foo', 'db_owner'
Go
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[jalbao]

exactly terry - that was what i overlooked.

thanks for the reply