Need PL/SQL - Alter User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Need PL/SQL - Alter User

  1. #1
    Join Date
    Nov 2000
    Posts
    173

    Need PL/SQL - Alter User

    Hi all,

    I need to create a package with 2 procedures that are executed with the definers privs(alter user), when a user logs into the application.

    -----one procedure would execute upon login
    issue the alter user command to set all db roles to default.

    -----the other would execute upon logout
    issue the alter user command to only set the connect role as default.

    Does anyone have a pkg/proc like this? Or other suggestions to accomplish this same task.

    Thanks,
    Kathy

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Create a procedure and call them in a trigger during login and logout
    Cheers!
    OraKid.

  3. #3
    Join Date
    Jan 2003
    Location
    india
    Posts
    175

    -----one procedure would execute upon login
    issue the alter user command to set all db roles to default.

    -----the other would execute upon logout
    issue the alter user command to only set the connect role as default.

    can i know

    what is the advantage of toggling like this?

    what is the problem of leaving the roles to what you want?

    what is the effect of setting it to something else,
    when the user is logged out?

    -Raja

  4. #4
    Join Date
    Dec 2000
    Posts
    138
    If you are using alter session set role why do you have to reset it?
    -dharma

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