Home » RDBMS Server » Security » for creating table in new user
icon6.gif  for creating table in new user [message #236713] Thu, 10 May 2007 12:27 Go to next message
samarendra_81
Messages: 10
Registered: April 2007
Location: india
Junior Member

hi

first i want you tell that , i am using my PC in which i have instaled oracle 8.1.7 and then dev. 6i

global database name given -->amar

for creating form builder ..

i have created a dba login id named DBA_AMAR and then granted DBA and selected privileges and roles...

under DBA_AMAR i have created a user SAM in which i had given default tablespaces named SCT_DATA . and then granted privileges as
create any table,
create table
create view
insert any table
select any table
update any table


all this USER AND DBA i have created due to form builder dont take the scott tables

so the problem is when i want create the table under user SAM
the below error occures..


SQL> create table test (n number(1));
create table test (n number(1))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SCT_DATA'

also i want to transfer the many tables created in user SCOTT

PLEASE GIVE ANY SOLN.

WITH REGARDS

WAITING FOR REPLY

SAMAR



Re: for creating table in new user [message #236720 is a reply to message #236713] Thu, 10 May 2007 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give the user quota on the target tablespace.

Regards
Michel
Re: for creating table in new user [message #236722 is a reply to message #236720] Thu, 10 May 2007 13:04 Go to previous messageGo to next message
samarendra_81
Messages: 10
Registered: April 2007
Location: india
Junior Member

can you plz tell me how can i do it.

thanks from samar
Re: for creating table in new user [message #236723 is a reply to message #236722] Thu, 10 May 2007 13:08 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter user <myuser> quota XXX on <mytablespace>

Regards
Michel
Previous Topic: OPS$
Next Topic: To know the user delete the table ?
Goto Forum:
  


Current Time: Fri Mar 29 08:24:37 CDT 2024