Results 1 to 3 of 3

Thread: oracle plSQL -- how to identify users and more.

  1. #1
    Join Date
    May 2005
    Posts
    111

    oracle plSQL -- how to identify users and more.

    what is the plsql to identify if a user exists in a database? and what is the syntax to reset a users password?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Query dba_users table.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    you can use

    alter user xxxx identified by yyyyy

    command.

    You should search the documentation before seeking answers in this forum.

Posting Permissions

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