Do you mean a User or a Login or both? There is a difference and a User is
no good without an associated Login. You may want to check out sp_adduser
and sp_addlogin in BooksOnLine.
--
Andrew J. Kelly
SQL Server MVP
"Steve Caliendo" <scaliendo@epion.com> wrote in message
news:e4Rvg8NREHA.1308@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Could someone please tell me how to add a database user using a query? I
> know how to set the appropriate permissions for tables of existing users,
> but I can't figure out how to add a new user.
>
> Thank you,
>
> Steve
>
>
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.programming)
RE: Web query problem when password required ...Madhan,... The problem with login is solved but the problem with query is not yet ....WebDisableDateRecognition = False ... (microsoft.public.excel.programming)
