November 25, 2015 at 6:50 pm
Hi.
May I ask the user has already create table access but it's still encountering error" The specified schema name "dbo" either does not exist or you do not have permission to use it error in create table"?
The fix was to add alter schema to dbo? May I know the reason why the create table is not enough even the command is just to create table? and why would the alter access suffice the access issue?
November 25, 2015 at 9:17 pm
not very clear by what you mean, but i'd guess the error is to do with not having access to the master schema to create a table and the need to specify the schema where you have access to create it.
November 26, 2015 at 2:37 am
so why wasn't it working if we already gave create table to the database? and why was the alter schema to dbo was the fix?
November 26, 2015 at 3:12 am
If you don't specify the schema on creation it will create the object in the users default schema.
If the user doesn't have permissions to alter that schema it will fail.
It is always best practice to double qualify all objects dbo.table, that way if you have table in user1 schema, user2 schema and dbo and your default schema is user2, and you do select * from table, you get user2.table where as you may want dbo.table so always best to prefix
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply