Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: revoke permission

    Is there ayway to revoke permission from schema owner user after schema owner user creates it to prevent them from doing drop objects etc..

    We tried to test to take away control permission for tablles and dropin from schema owner user but still that user can drop objects!Isn't it wierd ?

    TIA.

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    Are you sure that the user doesn't have a super-privilege such as DBADM?

    James Campbell

Posting Permissions

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