Create table rights

From: jaylou (jaylou_at_discussions.microsoft.com)
Date: 08/29/05 

Date: Mon, 29 Aug 2005 13:52:54 -0700

hi All,
I have given a user ddladmin to a database, but this user still can't create
tables. I tried to "grant create tables to username" that ran sucessfully
but still can't create a table in my DB.

Can anyone tell me what I missed for this user? he can drop tables but not
create them.
Thanks,
Joe

Relevant Pages

  • Re: Error accessing sql server
    ... You can do this using osql. ... Once you are logged in you can grant the user access to the ... database just type in sp_grantlogin <username> then GO. ...
    (microsoft.public.dotnet.languages.csharp)
  • Granting access on MySQL
    ... I need to grant a user access to a database. ... mysql> grant all on databasename.* to username; ... I got no error messages, but I after connecting as the user, I couldn't use the database. ...
    (freebsd-questions)
  • Re: Pathname to access and usernames in shortcut
    ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
    (microsoft.public.access.security)
  • RE: user permissions in a database as a whole or tables
    ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: user permissions in a database as a whole or tables
    ... like PDF better but that was not helping this time either. ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)