ORA-01031: insufficient privileges

Question

Hi.

I made dmp-file, transferred grants scheme.

But I can't enter into the FS IDE. Error: ORA-01031: insufficient privileges.

What it needs more?

Answer 1

Hi,

If the schema imported successfully with all its data and all necessary grants are given, then you will need to create a context to make Formspider work. Please use below script to create one.

declare
  v_contextNameSpace_tx varchar2(255);
begin
  select 'BUI_CTX_'||user_id into v_contextNameSpace_tx
  from all_users
  where username=sys_context('userenv','current_schema');
  execute immediate 'create or replace context '||v_contextNameSpace_tx||' using BDF_CONTEXT accessed globally';
end;
/

Answer 2

0	Thank you very much! Now everything works. link answered 14 Apr '15, 09:27 Ramil 41●3●37 accept rate: 0%

Answer 3

0	Oh, now do not have enough privileges within the application. ORA-01031: insufficient privileges ORA-06512: at "FS_DSK18_DEV.BDF_SCRIPTUTIL", line 170 ORA-06512: at "FS_DSK18_DEV.BDF_ENGINE", line 56 link answered 14 Apr '15, 09:59 Ramil 41●3●37 accept rate: 0%

Answer 4

0	Hi, Your Formspider schema has to have necessary rights to execute FS_DSK18_DEV.BDF_SCRIPTUTIL. Regards link answered 15 Apr '15, 07:18 Serdar ♦♦ 100k●4 accept rate: 13%

Answer 5

0	Thank you. Now everything works. link answered 15 Apr '15, 07:39 Ramil 41●3●37 accept rate: 0%

ORA-01031: insufficient privileges

Follow this question

Related questions