how to add new login to MS SQL with SQL call

Eugene V. Goldberg

Delphi Developer

Fri, 22 Jul 2005 20:28:14 GMT

how to add new login to MS SQL with SQL call

I want to use ADO query to add new login to MS SQL 2000
and set it as db_owner for the database,

How do i do that with SQL?

TIA,
Eugene.

--
ICQ: 35477912
MSN: eg...@mts-nn.ru
Yahoo: eugene_goldberg2000
AOL: egold2002

Alain Quesne

Delphi Developer

Fri, 22 Jul 2005 21:06:37 GMT

Re:how to add new login to MS SQL with SQL call

Take a look at sp_adduser or sp_addlogin in books online (MSSQL online
help).

Alain Quesnel
alainqsanss...@compuserve.com

"Eugene V. Goldberg" <EugeneGoldb...@mail.ru> wrote in message
news:3e3e605e@newsgroups.borland.com...

Quote

> I want to use ADO query to add new login to MS SQL 2000
> and set it as db_owner for the database,

> How do i do that with SQL?

> TIA,
> Eugene.

> --
> ICQ: 35477912
> MSN: eg...@mts-nn.ru
> Yahoo: eugene_goldberg2000
> AOL: egold2002

Eugene V. Goldber

Delphi Developer

Fri, 22 Jul 2005 21:28:59 GMT

Re:how to add new login to MS SQL with SQL call

Thanx Alain.

Quote

"Alain Quesnel" <alainqsanss...@compuserve.com> wrote in message

news:3e3e695c$1@newsgroups.borland.com...

Quote

> Take a look at sp_adduser or sp_addlogin in books online (MSSQL online
> help).

> --

> Alain Quesnel
> alainqsanss...@compuserve.com

> "Eugene V. Goldberg" <EugeneGoldb...@mail.ru> wrote in message
> news:3e3e605e@newsgroups.borland.com...
> > I want to use ADO query to add new login to MS SQL 2000
> > and set it as db_owner for the database,

> > How do i do that with SQL?

> > TIA,
> > Eugene.

> > --
> > ICQ: 35477912
> > MSN: eg...@mts-nn.ru
> > Yahoo: eugene_goldberg2000
> > AOL: egold2002

Other Threads

1. Add User/Login MS SQL 7

2. MS SQL Server login without NT login

3. NON-Stop Login requests for MS SQL in the IDE

4. MS SQL LOGIN

5. Login fails on trusted connection to ms-sql 2000

6. MS-SQL 6.5 & MS-SQL 2000

7. Ms sql 2000 login

8. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

9. Login information for MS SQL Server

10. Bypass DefaultDb for MS-SQL 2000 login, How?