Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to grant me permissions to my own tables ?
Do you have the 'connect' role activated for the user CCBURKE? I think this default role grants users access to the tables in their own schema.
Cheers,
Steve
Christopher Burke wrote:
> I created and filled a set of tables in Tablespace "CCBURKE" on an Oracle
> Server 8.0.6 on Solaris.
>
> Problem is that I don't have any permissions to the tables - how do I give
> myself permissions to read the tables.
>
> They are mine logging in as CCBURKE with the password works fine, but
> select * from CCBURKE.tablename returns a no such table error.
>
> CCBURKE is the user that created and filled the tables.
>
> I used an ODBC client to import the tables, the tables are actually there
> (I can see them in the GUI DBA Studio program).
>
> Help please.
Received on Fri Aug 04 2000 - 00:00:00 CDT