permissions error

Question

question

triviii asked Jun 3, '10

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-2008 permissions login user

10 |1200

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

Answer 1 · 2010-06-04T05:33:38Z

ThomasRushton answered Jun 4, '10

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

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

question