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?

asked 14 Apr '15, 08:20

Ramil's gravatar image

Ramil
41216
accept rate: 0%


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;
/
link

answered 14 Apr '15, 08:45

Serdar's gravatar image

Serdar ♦♦
100k4
accept rate: 14%

Thank you very much!

Now everything works.

link

answered 14 Apr '15, 09:27

Ramil's gravatar image

Ramil
41216
accept rate: 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's gravatar image

Ramil
41216
accept rate: 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's gravatar image

Serdar ♦♦
100k4
accept rate: 14%

Thank you. Now everything works.

link

answered 15 Apr '15, 07:39

Ramil's gravatar image

Ramil
41216
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3
×2

Asked: 14 Apr '15, 08:20

Seen: 1,049 times

Last updated: 15 Apr '15, 07:39


© Copyright Gerger 2017