Article View: pl.comp.bazy-danych
Article #183045Re: oracle10 i user read only
From: szkaradnik
Date: Tue, 23 Jun 2009 15:01
Date: Tue, 23 Jun 2009 15:01
13 lines
2166 bytes
2166 bytes
Trochę inaczej Stwórz rolę np. LAMMER_READ_ONLY Nadaj jej granta na selecty do wybranych tabel, jeśli wykorzystujesz określone schematy lub właściwości nazwy tabel wspomóż się sprytnym zapytaniem z views USER_TABLES and ALL_TABLES. SELECT 'GRANT SELECT ON ' || OWNER ||'.' || TABLE_NAME || ' TO LAMMER_READ_ONLY;' FROM ALL_TABLES WHERE OWNER IN 'RAPORTY' Stwórz użytkownika z podaną rolą LAMMER_READ_ONLY_ Jak przyjdzie nowy delikwent z podobną prośbą to tylko wystarczy nadać rolę po stworzeniu... Generalnie uprawnienia powinny być na poziomie roli nie użytkowników
Technical Details
Message-ID:
<b2804ac6-2379-4150-8173-7a913103e694@a36g2000yqc.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.190.251.MISMATCH!news-out.readnews.com!transit4.readnews.com!postnews.google.com!a36g2000yqc.googlegroups.com!not-for-mailReferences:
<80188694-0132-4dbd-916c-eb2d7b591b77@l2g2000vba.googlegroups.com> <069a6d4f-8370-482d-bd8c-0c7d3c7ef3a7@v38g2000vbb.googlegroups.com> <fd6c8224-c64c-4936-a79b-9d880994265e@v4g2000vba.googlegroups.com> <f1fe25f7471458a572c47266e3bac0a1@masel.cs.put.poznan.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.190.251.MISMATCH!news-out.readnews.com!transit4.readnews.com!postnews.google.com!a36g2000yqc.googlegroups.com!not-for-mail From: szkaradnik <szkaradnik@gmail.com> Newsgroups: pl.comp.bazy-danych Subject: Re: oracle10 i user read only Date: Tue, 23 Jun 2009 08:01:49 -0700 (PDT) Organization: http://groups.google.com Lines: 17 Message-ID: <b2804ac6-2379-4150-8173-7a913103e694@a36g2000yqc.googlegroups.com> 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> <f1fe25f7471458a572c47266e3bac0a1@masel.cs.put.poznan.pl> NNTP-Posting-Host: 83.238.13.18 Mime-Version: 1.0 X-Trace: posting.google.com 1245769310 26252 127.0.0.1 (23 Jun 2009 15:01:50 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 23 Jun 2009 15:01:50 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: a36g2000yqc.googlegroups.com; posting-host=83.238.13.18; posting-account=48yAYQkAAADIdrNm2-8voRzFtlH7KpNf User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11,gzip(gfe),gzip(gfe) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit