Re: oracle10 i user read only

Article View: pl.comp.bazy-danych

Article #183044

Back to pl.comp.bazy-danych Previous Next

#183044

From: Maseł
Date: Mon, 22 Jun 2009 12:47

22 lines
1503 bytes

hdd wrote:
> Zrobilem tak jak tu opisane:
> (as sys)
> CREATE USER new_user IDENTIFIED BY new_pwd;
> GRANT CONNECT, RESOURCE TO new_user;
> 
> (as old_user)
> GRANT SELECT ON table1 TO new_user;
> etc.
> 
> (as new_user)
> SELECT field1, field2, ... FROM old_user.table1;
> 
> I w zasadzie jest OK, oprocz tego ze nalezy podawac przed nazwa tabeli
> old_usera

Hmm to moze ten odjuzer zrobi aliasu publiczne albo newjuzer zobi se
aliasy prywatne?

Pozdro

Maseł

Technical Details

Message-ID: <f1fe25f7471458a572c47266e3bac0a1@masel.cs.put.poznan.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail

References:

<80188694-0132-4dbd-916c-eb2d7b591b77@l2g2000vba.googlegroups.com>  <069a6d4f-8370-482d-bd8c-0c7d3c7ef3a7@v38g2000vbb.googlegroups.com> <fd6c8224-c64c-4936-a79b-9d880994265e@v4g2000vba.googlegroups.com>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail
From: Maseł <mmasel@poczta.onet.pl>
Newsgroups: pl.comp.bazy-danych
Subject: Re: oracle10 i user read only
Date: Mon, 22 Jun 2009 14:47:15 +0200
Organization: http://onet.pl
Lines: 22
Message-ID: <f1fe25f7471458a572c47266e3bac0a1@masel.cs.put.poznan.pl>
References: <80188694-0132-4dbd-916c-eb2d7b591b77@l2g2000vba.googlegroups.com>  <069a6d4f-8370-482d-bd8c-0c7d3c7ef3a7@v38g2000vbb.googlegroups.com> <fd6c8224-c64c-4936-a79b-9d880994265e@v4g2000vba.googlegroups.com>
NNTP-Posting-Host: 87-205-225-78.adsl.inetia.pl
Mime-Version: 1.0
X-Trace: news.onet.pl 1245674853 9818 87.205.225.78 (22 Jun 2009 12:47:33 GMT)
X-Complaints-To: niusy@onet.pl
NNTP-Posting-Date: Mon, 22 Jun 2009 12:47:33 +0000 (UTC)
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
In-Reply-To: <fd6c8224-c64c-4936-a79b-9d880994265e@v4g2000vba.googlegroups.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message