Re: assiging a user to another user's tables

A copy of this was sent to Steven Egberghs <steven.egberghs_at_eni.be> (if that email address didn't require changing) On Wed, 20 Oct 1999 11:52:59 +0200, you wrote:

>Hi there
>Oracle8 NT4
>
>I have a user 'ADM' with create table-rights.
>A second user 'US1' has only connect-rights.
>
>How can I setup Oracle, so that when I connect as US1, I see the ADM's
>tables.
>
>
>Thx
>Steven

ADM will GRANT select on those tables that US1 should be able to see either

• directly to US1
• to some role which is granted to US1

US1 can then "select * from adm.TableName". If you want US1 to be able to "select * from tableaname" (no ADM.) either

• a DBA would create a public synonym "create public synonym tableName for adm.tableName"
• you would grant US1 the ability to create a synonym as well as connect so US1 could "create synonym tableName for adm.tableName".

then US1 would be able to "select * from tableName"

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Oct 20 1999 - 07:59:50 CDT