Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    98

    Unanswered: about user management

    is there a way to only manage users created by an single user?

    eg.

    user xxx has create user/resource priv with admin option.

    he creates a number of users with a profile with expiring password every 3 days.

    by the end of every 3 days, the password expires, but i would like xxx to only have 'alter user' privs on the users he created.

    is it possible?

    thanks

    Mark

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: about user management

    Originally posted by mchih
    is there a way to only manage users created by an single user?

    eg.

    user xxx has create user/resource priv with admin option.

    he creates a number of users with a profile with expiring password every 3 days.

    by the end of every 3 days, the password expires, but i would like xxx to only have 'alter user' privs on the users he created.

    is it possible?

    thanks

    Mark

    Hi,
    Check this link and it will help you solve your problem.

    http://www.ss64.com/ora/profile_c.html

    Hope it Helps
    nn

  3. #3
    Join Date
    Nov 2002
    Posts
    98
    thanks for the link, but i think my problem is a bit different.

    what i was trying to say is that i don't want to give user xxx system-wide 'alter user' privilege, but i just want to give him 'alter user' access on the users he created. so xxx won't accidetally mess up other user that doesn't involve him.

    mark

Posting Permissions

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