login id and user id. 
Author Message
 login id and user id.

I have a question about login id and user id.

If I create a new login id, the new login id must not use the existing user
id in the database? in other word, it is not possible to associate the login
id to the exsiting user id in the database? We must create new user id for
the login id creation?

The following statement will create a new user id NETDOMAIN\John?

sp_grantdbaccess 'NETDOMAIN\John'

Reason

======

From SQL online book:

name_in_db must not already exist in the current database

Is the name for the account in the database. name_in_db is an OUTPUT
variable with a data type of sysname, and a default of NULL. If not
specified, login is used. If specified as an OUTPUT variable with a value of

current database



Sat, 19 Nov 2005 11:42:38 GMT
 login id and user id.

see inline

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


Quote:
> I have a question about login id and user id.

> If I create a new login id, the new login id must not use the existing
user
> id in the database? in other word, it is not possible to associate the
login
> id to the exsiting user id in the database? We must create new user id for
> the login id creation?
yes.

> The following statement will create a new user id NETDOMAIN\John?

it will create the new user id.

- Show quoted text -

Quote:

> sp_grantdbaccess 'NETDOMAIN\John'

> Reason

> ======

> From SQL online book:

> name_in_db must not already exist in the current database


> Is the name for the account in the database. name_in_db is an OUTPUT
> variable with a data type of sysname, and a default of NULL. If not
> specified, login is used. If specified as an OUTPUT variable with a value
of

the
> current database



Sat, 19 Nov 2005 18:38:46 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. login ID vs user ID in connection string

2. why do we have a login id and user id

3. login ID vs user ID in connection string

4. change login id to a user

5. change login id for a user

6. HELP! with Login Names and User Ids

7. Associate multiple user accounts to a single Login ID

8. How to create login ID for every NT Domain users on SQL server 7.0

9. Validating NT User Login IDs

10. New User Login ID

11. Dropping Login Id's w/o dropping the users

12. Return user login id


 
Powered by phpBB® Forum Software