Create table permission

Question

1.00/5 (1 vote)

See more:

Hi,

I am creating a database through VB.NET code from a database level user and i want to create a table to it...I am getting exception as

 " There is already an object named 'xHawk' in the database.<br />
Cannot find the user 'test', because it does not exist or you do not have permission."

xHawk is the database i created..thanks in advance....please help me out...

Here is the query i wrote...

VB

Dim strTable As String = "GRANT CREATE TABLE TO test  CREATE TABLE xHawk(StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY," + "Name CHAR(50)," + "Address CHAR(255)," + "Contact INTEGER);"

Posted 27-Mar-12 0:05am

DileepkumarReddy

Updated 27-Mar-12 0:36am

Amir Mahfoozi

v4

Add a Solution

Comments

sachin10d 27-Mar-12 7:30am

you are having a xHawk database and your creating a table named xHawk in that database
is it right?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Zorro_ · Answer 1 · 2012-03-27T00:22:00

Hi,

It seems you are trying to create an already existing table, hence the "There is already an object named xHawk in the database".

Try using something like this, beware it will delete you table before creating it again:

SQL

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[xHawk]') AND type = N'U')
DROP TABLE [dbo].[xHawk]

Notice the [dbo], it is recommended to use schemas but if you don't, just remove "[dbo]".

Hope it helps.

sachin10d · Answer 2 · 2012-03-27T01:19:00

what _Zorro_ says is right
you will have to use this

SQL

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[xHawk]') AND type = N'U')
DROP TABLE [dbo].[xHawk]
go

GRANT CREATE TABLE TO test  CREATE TABLE xHawk(StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY,Name CHAR(50),Address CHAR(255),Contact INTEGER)

If the execption is related permission it gives the following error.

HTML

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
The specified schema name "dbo" either does not exist or you do not have permission to use it.

Create table permission

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0