Re: Accessing Table

Johnny Tjokro wrote in message <34DDFCB9.5B20359B_at_worldsite.net>...
>I have problem accessing table that is not belong to me in ORACLE.
>I can look at them by using select statement.
>But I can not put them into cursor....saying that I have not enough
>privileges.
>My account has programmer privileges and DBA privileges.

  Yep, I've been caught out like this as well. If you have the priviledge granted via a role to see another (or any) schema's objects, you may do so via SQL Plus & worksheet, but not via PL/SQL: you must be granted a select on that that object (or a select any).
  This pops up too if you wish to use the DBMS_SQL package to execute DDL SQL. i.e you cannot create a table in your own schema via PL/SQL normally as you have the create table priviledge given to you by rhe Resource role. To create a table via PL/SQL in your own schema you must be given the create table priviledge directly. I don't know how this goes in V8.

  Dave Received on Tue Feb 10 1998 - 00:00:00 CST