Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


grant permission help need - Error Msg 2760,


grant permission help need - Error Msg 2760,

Author
Message
SQL Galaxy
SQL Galaxy
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1218 Visits: 3465
Hi,

Please give me suggestion, how to resolve this issue?

--create Login script
--use master
CREATE LOGIN test1
WITH PASSWORD = 'SMTStest_1';

--use database name
--create user script
CREATE USER test1 FOR LOGIN test1
WITH DEFAULT_SCHEMA = dbo;
GO

--alter script to change which is assgin database this user.
ALTER LOGIN [test1] WITH DEFAULT_DATABASE=[test]

--Grant permission
GRANT CREATE TABLE TO [test1];


create table test3 (id_clo int)

Msg 2760, Level 16, State 1, Line 1
The specified schema name "dbo" either does not exist or you do not have permission to use it.
bopeavy
bopeavy
SSC Eights!
SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)

Group: General Forum Members
Points: 941 Visits: 690
Have you run down the obvious, like do you have the appropreate rights? Or You need to run under correct database and correct schema.

Cool


"There are no problems! Only solutions that have yet to be discovered!"


SQL Galaxy
SQL Galaxy
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1218 Visits: 3465
Yes, I have correct schema (dbo) and user name.

1. Login - test1 with pw ( default db is test)
2. query editor - USE database name
3. create table - but till facing same error.

rgds
ananda
bopeavy
bopeavy
SSC Eights!
SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)

Group: General Forum Members
Points: 941 Visits: 690
But do you have the permissions to use it?

Cool


"There are no problems! Only solutions that have yet to be discovered!"


Abhijit More
Abhijit More
SSC Eights!
SSC Eights! (943 reputation)SSC Eights! (943 reputation)SSC Eights! (943 reputation)SSC Eights! (943 reputation)SSC Eights! (943 reputation)SSC Eights! (943 reputation)SSC Eights! (943 reputation)SSC Eights! (943 reputation)

Group: General Forum Members
Points: 943 Visits: 767
It seems like you are not authorized to create login using deault schema. check the permissions you have on the server.

Abhijit - http://abhijitmore.wordpress.com
SQL Galaxy
SQL Galaxy
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1218 Visits: 3465
yes, I have full permission to use this server.

I login with sa user.. after that create one database name is test,
then create login, user etc.. and give command

grant create table to test1 ( user).


thanks
ananda
bopeavy
bopeavy
SSC Eights!
SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)SSC Eights! (941 reputation)

Group: General Forum Members
Points: 941 Visits: 690
I suggest that you check both logins sys.database_permissions: http://msdn.microsoft.com/en-us/library/ms188367.aspx

Cool


"There are no problems! Only solutions that have yet to be discovered!"


SQL Galaxy
SQL Galaxy
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1218 Visits: 3465
Hi,

As per you suggest this URL, I am not getting clearly,

so can you explain default schema(dbo) not able to give grant permission to particular user for create table, view, function, procedure, execute, insert, update, alter table column to developer

these permission how to assign to developer(SQL user) with default schema (DBO).

Thanks
ananda
Anoo S Pillai
Anoo S Pillai
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 433
Please refer the link on CREATE TABLE :- http://msdn.microsoft.com/en-us/library/ms174979.aspx

--------------------------------------------------------------------
Copying the permissions section from the link for easy reference

Permissions:-
Requires CREATE TABLE permission in the database and ALTER permission on the schema in which the table is being created.
----------------------------------

Means you should grant the following too
GRANT ALTER ON SCHEMA::dbo TO test1.
sangeet.tuladhar
sangeet.tuladhar
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 162
you need to have dbowner privileges to create table. Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search