Results 1 to 7 of 7

Thread: Ownership issue

  1. #1
    Join Date
    Jul 2004
    Posts
    23

    Unanswered: Ownership issue

    One of my apps uses a login that is tied down to only use the sprocs and tables it is allowed to access. Its just given 'public' role. However, it needs to be able to add and delete fields from one table in particular. Is there a way to allow this? The login it uses has been given full rights to the table but an alter table command faults. The tbale must be a 'dbo' because other apps use it -- can I be granted DDL rights on a per table basis?

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Wink Response

    Enterprise manager allow for table access specifically to tables, vies, store procedures etc.... Right can be assigned per table or view. Read, Write, Update, Delete.

  3. #3
    Join Date
    Jul 2004
    Posts
    23
    Yes they can...but not for alter table it seems.

  4. #4
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Response

    Alter table? Dump it out and bring it back in ussing DTS utl for easy cleanup.

  5. #5
    Join Date
    Jul 2004
    Posts
    23
    Huh?

    I want my app to issue an alter table command in SQL Server, it seems impossible without having dbowner in login -- which would seem massive overkill

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    According to the BOL in the description of the GRANT command, in thefootnote 1 for ALTER TABLE it says that the object owner can issue ALTER TABLE commands for the objects that they own. The table shows that the db_owner and db_ddladmin roles can issue ALTER TABLE commands for objects owned by other users.

    -PatP

  7. #7
    Join Date
    Jul 2004
    Posts
    23
    Thanks for clearing that up. Looks like I am stuffed really. Ah well...

    I have got around it temporarily by raising the rights on the accout, doing the operation and then lowering them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •