| saza |
Posted: Apr 29, 2008 06:05:38 AM |
Total Post: 13
Joined: Apr, 2008
|
Hi
How to cheak privilages for a user on a table Import?
and how to create a tablesp and make that defult tbls for a user.
(I am gonna import a database on that tablesp and only that user will have accses to it)
hope anyone can help me
thanks!
|
|
|
 GOPU |
| Posted: Apr 29, 2008 06:09:38 AM |  |
|
Total Post: 333
Joined: Apr, 2008
|
to check the privileges of a user u can go through the views
dba_priviliges
user_priviliges
all_priviliges
how to create a tablespace is
create tablespace <tablespace_name> datafile '/path of the datafile/filename.dbf' size 100m;
then to make that tablespace as the default tablespace of a user is
alter user <username> default tablespace <tablespace_name>;
|
|
|
|
|
| Gitesh |
| Posted: Apr 29, 2008 06:48:37 AM | |
|
Total Post: 322
Joined: May, 2005
|
One correction in above command. Give quota also to that user otherwise without quota user can't able to create table and insert in.
alter user user1 quota unlimited on <tablespace_name>;
|
|
|
|
|
| GOPU |
| Posted: Apr 29, 2008 06:52:58 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
thanks for correcting me Gitesh
|
|
|
|
|
| saza |
| Posted: Apr 29, 2008 08:21:08 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
