20070629 list accounts on the ebs database - plembo/onemoretech GitHub Wiki

title: list accounts on the EBS database link: https://onemoretech.wordpress.com/2007/06/29/list-accounts-on-the-ebs-database/ author: lembobro description: post_id: 681 created: 2007/06/29 21:02:00 created_gmt: 2007/06/29 21:02:00 comment_status: open post_name: list-accounts-on-the-ebs-database status: publish post_type: post

list accounts on the EBS database

Kind of related to the previous post.

I’m an sqlplus beginner. So I think this is really important info. Someday soon I’ll be embarrassed I even bothered to write this.

Log onto the EBS database as the APPS user.

sqlplus APPS/{appspw]@[dbname]

Then do this:

SQL> SPOOL /tmp/userlist.txt; SQL> SELECT USER_NAME FROM FND_USER; ... SQL> SPOOL OFF; SQL> quit

You’ll get a nice list of all the User ID’s on the database. The “SPOOL” command will print the output to the file indicated, so you don’t have to do a screen scrape.

If you want everything in the table substitute ‘*’ for ‘USER_NAME’.