DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Limiting actions on sys/system users

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Limiting actions on sys/system users

    Hi,

    We are using a third party application to manage our database user creation/alteration and dropping. For that we have created a database user which has create user, alter user and drop user privelege.

    We want to make sure that this user can never alter the sys/system user. Any suggestions on how to do this.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    You may need to create a DDL trigger to prevent this.
    -- OR --
    DO NOT grant the ALTER/DROP privileges to that account.


    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

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


Click Here to Expand Forum to Full Width