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: Getting NT User Login Names from Access 2000 or 2003
    ... time, i can recreate it in the blank database, per all your other thoughts. ... In the table setup and adding the bound SomeOtherField field to the ... >> form, plus binding the orig MyUserName field, defaulted to fOSUsername, to ... using the username field as ...
    (microsoft.public.access.formscoding)
  • Re: hashed password and UsernameTokenManager
    ... Sami ... > The reason for further hashing and salting the already hashed password is ... > you have the database. ... >>> to also use hashed password text to construct the username token... ...
    (microsoft.public.dotnet.framework.webservices.enhancements)