Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Duplicate Users

Re: Creating Duplicate Users

From: Alexander Romanov <sashar_at_comita.spb.ru>
Date: Tue, 24 Aug 1999 17:42:27 +0400
Message-ID: <7pu7mp$3f3$1@dragon.infopro.spb.su>


Hello
> I've got 15 tables setup for full access owned by xxx user. I want to
> let user yyy access these tables but as read only. How do you do this?
> yyy user is already setup with correct object select rights, but I am
> trying to figure out how to get the table views of user xxx to exist
> when logging in as user yyy.

  1. You should give the command GRANT from a login name user XXX or
  2. Create public synonym (if this action does not create a problem duplication of names)

Best regards
Всех Благ
---
Origin ... Просто надо очень верить этим синим маякам... Romanov Alexander
Alex_Romanov_at_mail.ru
ICQ 6220754 Received on Tue Aug 24 1999 - 08:42:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US