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

Thread: Find role creation date

  1. #1
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

    Find role creation date

    How do I find out when a role was created in a database.

    Version of interest was on 10gR2

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    try this ...

    select name, ctime from user$ where type# = 0;

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thank you.
    Thanx
    Sam



    Life is a journey, not a destination!


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