Creating a User

Hi,
I am having a problem while creating an user to a DB.
When I Click users --> New Database User --> it opens an New user
creation window. Under the login name the -drop down I have this User
"user_ABC" listed. (I don't know how this user ended up in this drop
down). I select this login name and keep the deafult user name -->
which is also "user_ABC" , give appropriate rights and click OK. When
I refresh the users list, this user is listed in the list. Allthough
when the user tries to access the database, he gets an error message
as "permission denied" .
To solve this problem, I deleted user "user_ABC" from the users list.
Refresh the list the user "user_ABC" is not present. Try to create a
new user, the deleted user is still exist in the Login Name: drop down
list.
Can anybody please help me understand what is going wrong in creating
a user?
Thanks in Adv.
Sunitadeleting a user from a database does not delete the login.
the login is what appears in the drop down you talk about.
go to security->logins and try managing the user account from there.
Sunita wrote:
> Hi,
> I am having a problem while creating an user to a DB.
> When I Click users --> New Database User --> it opens an New user
> creation window. Under the login name the -drop down I have this User
> "user_ABC" listed. (I don't know how this user ended up in this drop
> down). I select this login name and keep the deafult user name -->
> which is also "user_ABC" , give appropriate rights and click OK. When
> I refresh the users list, this user is listed in the list. Allthough
> when the user tries to access the database, he gets an error message
> as "permission denied" .
> To solve this problem, I deleted user "user_ABC" from the users list.
> Refresh the list the user "user_ABC" is not present. Try to create a
> new user, the deleted user is still exist in the Login Name: drop down
> list.
> Can anybody please help me understand what is going wrong in creating
> a user?
> Thanks in Adv.
> Sunita|||Thanks, it solved my problem.
Sunita
chxxx <chxxx@.dontemailme.com> wrote in message news:<3FB28F16.36350FA8@.dontemailme.com>...
> deleting a user from a database does not delete the login.
> the login is what appears in the drop down you talk about.
> go to security->logins and try managing the user account from there.
>
> Sunita wrote:
> > Hi,
> >
> > I am having a problem while creating an user to a DB.
> >
> > When I Click users --> New Database User --> it opens an New user
> > creation window. Under the login name the -drop down I have this User
> > "user_ABC" listed. (I don't know how this user ended up in this drop
> > down). I select this login name and keep the deafult user name -->
> > which is also "user_ABC" , give appropriate rights and click OK. When
> > I refresh the users list, this user is listed in the list. Allthough
> > when the user tries to access the database, he gets an error message
> > as "permission denied" .
> >
> > To solve this problem, I deleted user "user_ABC" from the users list.
> > Refresh the list the user "user_ABC" is not present. Try to create a
> > new user, the deleted user is still exist in the Login Name: drop down
> > list.
> >
> > Can anybody please help me understand what is going wrong in creating
> > a user?
> >
> > Thanks in Adv.
> > Sunita|||Try setting up the user from Security > Logins rather than
at the database level. You should probably delete the
user from the database first if he is still there and
reset the password at the login level. In Security >
Logins you can select which database the user should have
access to. When you go back to that database, he should
be there. You can set up permissions.
>--Original Message--
>Hi,
>I am having a problem while creating an user to a DB.
>When I Click users --> New Database User --> it opens an
New user
>creation window. Under the login name the -drop down I
have this User
>"user_ABC" listed. (I don't know how this user ended up
in this drop
>down). I select this login name and keep the deafult user
name -->
>which is also "user_ABC" , give appropriate rights and
click OK. When
>I refresh the users list, this user is listed in the
list. Allthough
>when the user tries to access the database, he gets an
error message
>as "permission denied" .
>To solve this problem, I deleted user "user_ABC" from the
users list.
>Refresh the list the user "user_ABC" is not present. Try
to create a
>new user, the deleted user is still exist in the Login
Name: drop down
>list.
>Can anybody please help me understand what is going wrong
in creating
>a user?
>Thanks in Adv.
>Sunita
>.
>

Create was Alter

In query Analyzer I right click on a stored procedure and click edit. In the
pass it displayed ALTER and now it displays CREATE. How can I put it back?
Thanks,
DaveClick "Script Object to New Window As" > "CREATE" rather than "Edit".
Then you'll have to drop the proc before you can run the script, which
is why Edit puts in the ALTER statement instead of CREATE.
David Portas
SQL Server MVP
--|||Its just sql trying to helpful. It assumes as you are looking at it you abou
t
to change it, so it helpfully changes the create to an alter. I does not
effect you schema in any way.
You can prove this by scripting the database.
"Government does not solve problems; it subsidizes them."
Ronald Reagan
"Dave" wrote:

> In query Analyzer I right click on a stored procedure and click edit. In t
he
> pass it displayed ALTER and now it displays CREATE. How can I put it back?
> Thanks,
> Dave|||Apologies for the previous post, I must learn to read properly.
I take it that edit ->Script Object to New Window->alter doesn't work ?
"A politician needs the ability to foretell what is going to happen
tomorrow, next w, next month, and next year. And to have the ability
afterwards to explain why it didn't happen."
Winston Churchill
"Dave" wrote:

> In query Analyzer I right click on a stored procedure and click edit. In t
he
> pass it displayed ALTER and now it displays CREATE. How can I put it back?
> Thanks,
> Dave|||I ment when I click "Edit" I get CREATE now. I have been using the for years
and now it changed
"David Portas" wrote:

> Click "Script Object to New Window As" > "CREATE" rather than "Edit".
> Then you'll have to drop the proc before you can run the script, which
> is why Edit puts in the ALTER statement instead of CREATE.
> --
> David Portas
> SQL Server MVP
> --
>|||You may have made some subtle change to the spacing or
commenting of the beginning of the procedure. The script
generator identifies "create" naively and changes it to ALTER
where it is found. If you create the following procedures,
you'll see that pCREATE comes up with CREATE when
you edit it, pALTER comes up with ALTER when you
edit it, and oopsCREATE comes up with a wrong procedure
name oopsALTER when you edit it!
CREATE PROC pALTER (
@.i int
) as select 'pALTER'
go
CREATE
PROC pCREATE (
@.i int
) as select 'pCREATE'
go
CREATE
--
PROC oopsCREATE (
@.i int
) as select 'Oops!!'
go
-- Steve Kass
-- Drew University
Dave wrote:
>I ment when I click "Edit" I get CREATE now. I have been using the for year
s
>and now it changed
>"David Portas" wrote:
>
>|||It seems like they fixed that, Steve. I get ALTER in each case on
8.00.818.
David Portas
SQL Server MVP
--|||I had a comment directly above. I put a blank line in and then it worked.
Thanks Everyone,
Dave
"David Portas" wrote:

> It seems like they fixed that, Steve. I get ALTER in each case on
> 8.00.818.
> --
> David Portas
> SQL Server MVP
> --
>|||Strange. I'm also running 8.00.818, and I do not get ALTER in each case.
The object browser version must not be completely dependent on the
server version.
SK
David Portas wrote:

>It seems like they fixed that, Steve. I get ALTER in each case on
>8.00.818.
>
>