Re: tables and tablespaces

First some general tips.... Create another tablespace for creation of user tables, views, etc... Also create a DBA user different from the system user.

In the situation you mentioned you can do the following. Login as system and do the following...

Grant select on "test" to user(u);

This will allow user U to select from the test table. You could also create a role that allows that privilege and any others you wish user (u) to have.

HTH RHC
Leif Kuschel wrote:
>
>
> Hello all,
>
> here my question ( I hope the last for today :-) ).
>
> Following situation:
>
> I have a user (u) with properties
>
> default Tablespace: x
> temporary Tablespace: SYSTEM
>
> and the privilege
>
> Admin
Option
> ALTER SESSION no
> CREATE DATABASE LINK no
> CREATE PROCEDURE no
> CREATE SESSION no
> CREATE SYNONYM no
> CREATE TABLE no
> CREATE VIEW no
>
> I created a table in the tablespace SYSTEM like "test" as user "system".
>
> Now the user (u) must select the table "test". What I have to do ?
> Is it possible or not ?
>
> thanks, Leif
>
>
>
>

--
Posted via CNET Help.com
http://www.help.com/ Received on Wed Feb 09 2000 - 12:30:54 CST