Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Unanswered: Grant Permissions to Dropping Procedures, tables, views, functions


    I have created a role.
    Then i have create a user and assigned the above role. I don't to give this user a admin role.
    Now i have given all the Select, insert, update, delete permissions and also create command permissions to this user.

    I need to give the drop permissions to this user. Because there are many existing objects in the database.

    Is there is any way to give the drop permissions, can someone respond quickly and resolve my issue.

    Thanks in advance.


  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    Sybase ASE 15.0 Reference Manual:
    SyBooks Online

    drop procedure permission defaults to the procedure owner and is not transferable

Posting Permissions

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