0

I created some tables using DBO_USER which had default tablespace as USERS. I moved these tables to another tablespace which is DBO_TS. I have another user APP_USER which tries to insert into these tables created by DBO_USER and APP_USER has unlimited grants and quotas on DBO_TS tablespace. APP_USER gets the error message ORA-01950: no privileges on tablespace 'USERS'. I can't alter the user as mentioned in

ORA-01950: no privileges on tablespace 'USERS'.

I want to know the following:

  1. Why error still refers back to USERS tablespace?

  2. How can I enable APP_USER to insert into tables created by DB_USER without altering the user and default tablespace of the user?

Thanks.

Rakesh
  • 4,004
  • 2
  • 19
  • 31
  • Does APP_USER do the INSERT directly or via a stored procedure? If the latter, who owns the stored procedure? – TenG Nov 17 '18 at 11:52
  • It inserts Directly – Rakesh Nov 17 '18 at 11:52
  • Was APP_USER able to insert prior to the move? – TenG Nov 17 '18 at 11:54
  • No which is the reason why I moved the tables to DBO_TS – Rakesh Nov 17 '18 at 12:43
  • Are there any indexes/LOBS on the table that are still in the USERS tablespace? – TenG Nov 17 '18 at 14:42
  • @TenG No indexes/LOBS used in the table – Rakesh Nov 17 '18 at 14:43
  • Then you need to post some more details about the table and the user privs here, e.g. dba_ts_quota for APP_USER, dba_tables. I presume that APP_USER has logged out and back in agian to the database since the grant was issued. – TenG Nov 17 '18 at 15:05
  • There must be some object still in the USERS tablespace. That's about all anyone can say from what you've told us. A working demo would really help. – William Robertson Nov 18 '18 at 10:02
  • No objects were in Users tablespace as i moved all of them to DBO_TS. I had to change the default tablespace and drop and recreate the objects to make it work. I will check if i can create it out of office. – Rakesh Nov 18 '18 at 10:06

0 Answers0