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

Thread: want scripts

  1. #1
    Join Date
    Jun 2002
    Posts
    1

    Question

    Hi,
    I build a Report Generator application for one oracle database. I make public synonym for tables . and grant(Select) them to report generator users.
    so i need some scrits for doing following actions, who can help me?
    1) list table_names and comments of them that report generator user has access to them.
    2) list all related tables(with foriegn key) of one table;
    3) list columns and comments of one table .

    attention that we are login with report generator user and want to get this information from other user(MIS User)

    Good Luck
    M. Siroos

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS;
    
    SELECT A.CONSTRAINT_NAME, A.TABLE_NAME, B.TABLE_NAME R_TABLE_NAME
    FROM ALL_CONSTRAINTS A, ALL_CONSTRAINTS B
    WHERE A.CONSTRAINT_NAME=B.R_CONSTRAINT_NAME;
    
    SELECT OWNER, TABLE_NAME, COLUMN_NAME, COMMENTS FROM ALL_COL_COMMENTS;
    Sanjay

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