OraFAQ Forum: Security » for creating table in new user

Home » RDBMS Server » Security » for creating table in new user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

for creating table in new user [message #236713]

Thu, 10 May 2007 12:27

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

Report message to a moderator