I am a little rusty but wouldn't granting "select any table" to the
user work if what you REALLY want is to see all data irrespective of
schema?

Rob

On Nov 16, 5:00 pm, DanRegalia <drega...@gmail.com> wrote:
> Hey All,
> I've gone thru some of the documentation over at Oracle about creating
> a 
> user:http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm
>
> CREATE USER jward
>     IDENTIFIED BY aZ7bC2
>     DEFAULT TABLESPACE data_ts
>     QUOTA 100M ON test_ts
>     QUOTA 500K ON data_ts
>     TEMPORARY TABLESPACE temp_ts
>     PROFILE clerk;
> GRANT connect TO jward;
>
> And this all looks like it makes sense, however,  I don't see where I
> would specify read only access..
>
> Say I wanted my user to have total access across all schemas to be
> able to pull any data down, but it can only have read access across
> them all, what would the SQL Look like?
>
> Thanks,
>
> ~Dan

-- 
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to