Re: oracle10 i user read only

Article View: pl.comp.bazy-danych

Article #183042

Back to pl.comp.bazy-danych Previous Next

#183042

From: hdd
Date: Mon, 22 Jun 2009 11:58

14 lines
1671 bytes

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

Technical Details

Message-ID: <fd6c8224-c64c-4936-a79b-9d880994265e@v4g2000vba.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!feed.news.interia.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!v4g2000vba.googlegroups.com!not-for-mail

References:

<80188694-0132-4dbd-916c-eb2d7b591b77@l2g2000vba.googlegroups.com>  <069a6d4f-8370-482d-bd8c-0c7d3c7ef3a7@v38g2000vbb.googlegroups.com>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!feed.news.interia.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!v4g2000vba.googlegroups.com!not-for-mail
From: hdd <hddgrzesia@gmail.com>
Newsgroups: pl.comp.bazy-danych
Subject: Re: oracle10 i user read only
Date: Mon, 22 Jun 2009 04:58:16 -0700 (PDT)
Organization: http://groups.google.com
Lines: 14
Message-ID: <fd6c8224-c64c-4936-a79b-9d880994265e@v4g2000vba.googlegroups.com>
References: <80188694-0132-4dbd-916c-eb2d7b591b77@l2g2000vba.googlegroups.com>  <069a6d4f-8370-482d-bd8c-0c7d3c7ef3a7@v38g2000vbb.googlegroups.com>
NNTP-Posting-Host: 212.87.231.106
Mime-Version: 1.0
X-Trace: posting.google.com 1245671896 16696 127.0.0.1 (22 Jun 2009 11:58:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 22 Jun 2009 11:58:16 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v4g2000vba.googlegroups.com; posting-host=212.87.231.106;  posting-account=SvOoQgoAAABnL-9FC8iO7Q63S7A1FLSA
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US)  AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.28 Safari/530.5,gzip(gfe),gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Reply to Parent Message