newbie question

how do I grant a user permission to a database from sql server mgmt studio
express ?
I used admin to create the database, granted the user smith full access to
the directory and files for the database. I tried grant the login id smith
access by simply smith as well as mypc\smith. both were rejected
how should I go about granting user permission?Hi
I don;t use SQL Server 2005 Management Studio Express but this describes how
to do the tasks
http://www.microsoft.com/technet/pr...lexpwssmse.mspx
You may want use SQLCMD and the CREATE LOGIN/CREATE USER commands if you
have a large number of logins/users to create.
John
"GS" wrote:

> how do I grant a user permission to a database from sql server mgmt studio
> express ?
> I used admin to create the database, granted the user smith full access to
> the directory and files for the database. I tried grant the login id smit
h
> access by simply smith as well as mypc\smith. both were rejected
> how should I go about granting user permission?
>
>|||thank you
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:944A0AF9-6167-4698-8610-571B3E8C3148@.microsoft.com...
> Hi
> I don;t use SQL Server 2005 Management Studio Express but this describes
how[vbcol=seagreen]
> to do the tasks
> http://www.microsoft.com/technet/pr...lexpwssmse.mspx
> You may want use SQLCMD and the CREATE LOGIN/CREATE USER commands if you
> have a large number of logins/users to create.
> John
> "GS" wrote:
>
studio[vbcol=seagreen]
to[vbcol=seagreen]
smith[vbcol=seagreen]