How to create a user in db without Login?

Question

Post reply

How to create a user in db without Login?

forsqlserver

SSCoach

Points: 18902
More actions
November 15, 2011 at 4:12 am

#260033

How to create a user in db without Login?
In some databases I have seen it.
Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Rhox Hall of Fame Points: 3462 More actions · Answer 1

In SSMS, select your database, select 'Security', right-click 'Users' : 'New users...'

Ok, found your problem.. 🙁

You cann't select "Without login" 🙁

Rhox Hall of Fame Points: 3462 More actions · Answer 2

USE AdventureWorks2008R2 ;

CREATE USER CustomApp WITHOUT LOGIN ;

GRANT IMPERSONATE ON USER::CustomApp TO [adventure-works\tengiz0] ;

GO

http://msdn.microsoft.com/en-us/library/ms173463.aspx

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

Rhox (11/15/2011)
In SSMS, select your database, select 'Security', right-click 'Users' : 'New users...'
Ok, found your problem.. 🙁
You cann't select "Without login" 🙁

OR

CREATE USER user_name

[ { { FOR | FROM }

{

LOGIN login_name

| CERTIFICATE cert_name

| ASYMMETRIC KEY asym_key_name

}

| WITHOUT LOGIN

]

[ WITH DEFAULT_SCHEMA = schema_name ]

forsqlserver SSCoach Points: 18902 More actions · Answer 4

A user without login..go db-->security-->right click users--->User's properties is showing without login...

A new user always created with Login name.

Thanks

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

USE AdventureWorks2008R2 ;

CREATE USER CustomApp WITHOUT LOGIN ;

http://msdn.microsoft.com/en-us/library/ms173463.aspx

forsqlserver SSCoach Points: 18902 More actions · Answer 6

If I want to create a login with insert view update and delete permission.. How Can I give these permissions to a login...

Thanks

viiki.seth Ten Centuries Points: 1127 More actions · Answer 7

see this:

http://msdn.microsoft.com/en-us/library/ms187965.aspx

aby_dvd Ten Centuries Points: 1310 More actions · Answer 8

@Eights - "A user without login..go db-->security-->right click users--->User's properties is showing without login..."

I followed it , but i am not able to select without login while creating a user for the 1st time .

Help !!!!

forsqlserver SSCoach Points: 18902 More actions · Answer 9

forsqlserver

SSCoach

Points: 18902

November 16, 2011 at 12:36 am

#1408276

Use the command with "Without Login"

Thanks

fitsumkh SSChasing Mays Points: 652 More actions · Answer 10

I believe this is orphaned user, basically if you restore a production database to dev or staging, and the user only has access in prod it shows up in the dev as orphaned. Unless the user is mapped it is kind of useless.