creating a user

[ter055]

Hello,

I am trying to create a user (using the user "sys" for it), who should have only rights to see/create/modify the tables were created by himself.

He should not even see other things in the database.

Advices?

Thanks!
Regards

[davey23uk]

create user x identified by y;
grant create session to x;
grant create table to y;

They wont be able to see any other schemas UNLESS they have been granted to public

[ter055]

Thanks davey!

what is "y" in this case?

[davey23uk]

the password for the user.

Should of been x in the grant create table statement - sorry

[ter055]

now I have the problem (after following your indications), that the user x cannot create a table:

SQL> create table mytable(mt_num number);
create table mytable(mt_num number)
*

ORA-01950: no privileges on tablespace 'SYSTEM'

[hacketta1]

The problem here is that you did not specifiy the default tablespace for the user when you created it, thus it defaults to SYSTEM and the user has a 0 quota on that tablespace. You should NEVER create user segments in the SYSTEM tablespace, so it's good this didn't work. Choose the tablespace you want the user to create their tables etc. in (let's assume you choose the USERS tablespace):

ALTER USER WHOEVER DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;

Now the user has an unlimited quota on their tablespace, and consume as much space as there is available. You could of course limit their quota by specifying bytes, kilobytes or whatever

[ter055]

.

Thank you both for helping me on this!