Post reply

SQL Permissions

  • November 9, 2004 at 3:20 pm

    #109675

    I have a database that users are allowed to create tables in via the ddladmin role. Is there another way to give the users the rights to create tables but not alter or drop objects.

  • November 10, 2004 at 1:05 am

    #529561

    Yes. You can 

    USE database
GRANT CREATE TABLE TO user

    The user can then create tables in their own userspace / schema. BUT they can also delete the tables they create. Just they can't delete someone else's tables/objects.

    Julian Kuiters
    juliankuiters.id.au

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply