CREATE TABLE permission denied in database

Hello,

I hope this is something simple to fix, but so far I had no luck...

Situation:

I created sql login, let's say 'test' and allowed access to database db1. Actually, I made the account as the db_owner of db1. The test account was not added to any of the server roles. Now, everything is working fine until I try to create table or view or proc, etc. in the db1 while logged in as the test user.

When creating table I get that CREATE TABLE permission denied in database 'scs_auto_uugdb09'. I tried executing GRANT CREATE TABLE after logging on as sysadmin to that test account. That didn't help. IS there some DENY somewhere that I don't see? How can I check what is preventing me from creating table using that account?

Any comments?

Thanks
.

Relevant Pages

  • create table permission denied
    ... I created sql login, let's say 'test' and allowed access to database db1. ... I tried executing GRANT CREATE TABLE after logging on as sysadmin to that test account. ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot save a file - button is shaded
    ... I have just tried in A2000 to do just what you did; I do a File - New, it makes a database db1 in the default location, and brings me to the database window. ... The same happens when I go to table design - I create a sample table, save it at the prompt when exiting the table design, and the Save Button is dimmed. ... It's only active when there are unsaved changes. ...
    (microsoft.public.access.setupconfig)
  • Re: Template form for CreateForm
    ... How do I delete a form in MyDB from code in DB1? ... >>I have a database DB1 that creates a form in another ... >>is not based om FMmaster. ...
    (microsoft.public.access.modulesdaovba)