question about user access to tables
Date: Mon, 3 Aug 2009 09:28:38 -0700 (PDT)
Message-ID: <563243ce-4f18-4bdc-9018-e8624c392c0e_at_j9g2000prh.googlegroups.com>
I have a situation that's stumping me for some reason.
I have an Oracle 9i system, with a database called abcweb.
One user of it, called abcuser, accesses it via something like
"sqlplus abcuser_at_abcweb_dev.WORLD/pswd1", with ORACLE_SID=abcweb.
They see all the tables in the database, per the
"select owner, table_name from all_tables;" command; the tables
are all owned by the ABCADM account.
Another user of it, called defuser, accesses it via something like
"sqlplus defuser_at_abcweb_dev.WORLD/pswd2", with the same ORACLE_SID.
They see only some of the tables in the database that the
first user sees, again per the
"select owner, table_name from all_tables;" command; the tables
they do see are also owned by the ABCADM account.
I want to make it so that the second user, defuser, can see the same
tables that the first user abcuser sees. How do I do this? What
table
or tool or command controls this? (Obviously, I didn't set up this
arrangement, and don't have deep Oracle knowledge.)
I've searched and looked at a bunch of things, but none of them
really address this ... I must be missing something simple ... thanks
for any help.
Jonathan Schilling Received on Mon Aug 03 2009 - 11:28:38 CDT