x

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.

more ▼

asked Jun 03, 2010 at 07:52 PM in Default

avatar image

triviii
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jun 04, 2010 at 05:33 AM

avatar image

ThomasRushton ♦♦
42.4k 20 60 54

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2221
x123
x110
x32

asked: Jun 03, 2010 at 07:52 PM

Seen: 1202 times

Last Updated: Jun 04, 2010 at 03:56 AM

Copyright 2018 Redgate Software. Privacy Policy