question

triviii avatar image
triviii asked

permissions error

use master
go
grant CREATE ANY DATABASE to Jack;
go

Msg 15151, Level 16, State 1, Line 1 Cannot find the login 'Jack', because it does not exist or you do not have permission.

here jack is not in my database. My problem here is i want to give access to jack on my server so that he can copy a backup of his database into my server. He is an user of another database.

sql-server-2008permissionsloginuser
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered

It seems to me as though you first need to grant "Jack" access to your server - CREATE LOGIN or sp_addlogin are your friends here.

Once he's a valid user on the server, then you can give him the permissions he needs...

http://technet.microsoft.com/en-us/library/ms189751.aspx for more information on "CREATE LOGIN" command.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.