Re: How to grant me permissions to my own tables ?

No, it does not. It has privileges like CREATE TABLE, but no object privileges. The owner of a table automatically has all privileges for this table. I suggest that the original poster verify his connection.

Regs
Karen

Steve Davidson wrote:

> 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