Results 1 to 4 of 4

Thread: too many tables

  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: too many tables

    We have users which utilize Brio (it's like MSAccess), but when they try to select tables for their gui SQL Builder, they get way more tables than they have access to even query against. How can I limit their query against ALL_TABLES to only those tables they should see?
    Code:
    SQL> create user cf identified by oracle;
    
    User created.
    
    SQL> grant create session to cf;
    
    Grant succeeded.
    
    SQL> grant select on cars.ardmrt to cf;
    
    Grant succeeded.
    
    SQL> connect cf/oracle@test;
    Connected.
    SQL> select count(*) from all_tables;
    
      COUNT(*)
    ----------
          1655
    I expected to only see one table here.
    --=Chuck

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How can I limit their query against ALL_TABLES to only those tables they should see?
    Construct a WHERE clause that results in "only those tables they should see".

    Does PUBLIC have rights the additional tables?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    Sorry, I just grabbed the SQL, and the following is the SELECT stmt issued by the software. I don't know that I'd have control over the WHERE clause:

    Code:
    SELECT DISTINCT table_name, '*', owner, table_type, '*'
    FROM            SYS.all_catalog
    WHERE           owner NOT IN( 'SYS', 'SYSTEM', 'PUBLIC' )   AND
                    table_type IN( 'TABLE', 'VIEW', 'SYNONYM' );
    From this SQL statement, you can see that PUBLIC tables are being excluded.
    ---=Chuck

  4. #4
    Join Date
    Dec 2003
    Posts
    1,074
    Turns out there's a filter for "OWNER" in the setup. Sorry to bug ya'll. We're unofficially supporting Brio, so I only learn more about it when there are problems. ---=cf

Posting Permissions

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