Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

grant permission help need - Error Msg 2760, Expand / Collapse
Author
Message
Posted Wednesday, July 13, 2011 5:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
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.

Post #1140893
Posted Wednesday, July 13, 2011 5:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:18 AM
Points: 941, Visits: 669
Have you run down the obvious, like do you have the appropreate rights? Or You need to run under correct database and correct schema.



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

Post #1140896
Posted Wednesday, July 13, 2011 5:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
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
Post #1140901
Posted Wednesday, July 13, 2011 5:48 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:18 AM
Points: 941, Visits: 669
But do you have the permissions to use it?


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

Post #1140902
Posted Wednesday, July 13, 2011 5:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 10, 2014 2:36 AM
Points: 924, Visits: 714
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
Post #1140905
Posted Wednesday, July 13, 2011 5:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
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
Post #1140908
Posted Wednesday, July 13, 2011 5:59 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:18 AM
Points: 941, Visits: 669
I suggest that you check both logins sys.database_permissions: http://msdn.microsoft.com/en-us/library/ms188367.aspx


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

Post #1140914
Posted Wednesday, July 13, 2011 6:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:41 PM
Points: 1,076, Visits: 3,050
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
Post #1140947
Posted Wednesday, July 13, 2011 7:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 31, 2014 7:16 PM
Points: 235, Visits: 372
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.

Post #1140962
Posted Friday, August 8, 2014 2:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 6:50 AM
Points: 1, Visits: 98
you need to have dbowner privileges to create table. Thanks
Post #1601329
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse