Re: OK - I'm stupid....How do you create a user?
- From: "Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 16 Nov 2006 08:58:04 -0800
The command completes successfully. I can see the user and the login. But
I can't login as the user. What else do I need to do?
What error message do you get?
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"UJ" <fred@xxxxxxxxxxx> wrote in message
news:%23N7xadZCHHA.1012@xxxxxxxxxxxxxxxxxxxxxxx
OK. I'm doing something wrong. I execute the following statements:
use mktg
go
create login stoelle with password = 'sharon'
go
create user stoelle for login stoelle
go
grant select on referrals to stoelle
go
grant delete on referrals to stoelle
go
grant update on referrals to stoelle
go
grant insert on referrals to stoelle
go
The command completes successfully. I can see the user and the login. But
I can't login as the user. What else do I need to do?
TIA - Jeff.
"Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OslCL5RCHHA.144@xxxxxxxxxxxxxxxxxxxxxxx
You might find the topics under this tutorial useful.
http://msdn2.microsoft.com/en-us/library/ms365345.aspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no
rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"UJ" <fred@xxxxxxxxxxx> wrote in message
news:OsHzQQPCHHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
OK - I'm stupid. How do you create a user? I've gone through the steps
of creating the user for the server, then create the user for the db but
the user cannot login.
Can somebody point me towards a web page/article that will tell me how
to do this?
TIA - Jeff.
.
- Follow-Ups:
- References:
- OK - I'm stupid....How do you create a user?
- From: UJ
- Re: OK - I'm stupid....How do you create a user?
- From: Gail Erickson [MS]
- Re: OK - I'm stupid....How do you create a user?
- From: UJ
- OK - I'm stupid....How do you create a user?
- Prev by Date: SQL 2000 login problem
- Next by Date: Re: SQL Server 2005 Database Security
- Previous by thread: Re: OK - I'm stupid....How do you create a user?
- Next by thread: Re: OK - I'm stupid....How do you create a user?
- Index(es):
Relevant Pages
|
|
