Home » Server Options » Text & interMedia » grant privileges for multi_column_datastore
grant privileges for multi_column_datastore [message #128469] Mon, 18 July 2005 14:42 Go to next message
Ragoo22
Messages: 4
Registered: March 2005
Junior Member
Hello all,

I am trying to create a multi_column_datastore by first creating the preference and setting the attributes (column names associated with the table to be indexed). I am also aware that I need to grant my user privileges to access the ctx_ddl package that contains the create_preference and set_attribute functions.

I connect to my ctxsys user and:

grant execute on ctx_ddl to my_user;

However, when I connect again to my_user, and try to create the preference I get this error:

ORA-20000: Oracle Text error:
DRG-12607: only ctxsys can create MULTI_COLUMN preferences
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CTX_DDL", line 55

Can anyone help? Thanks!

Report message to a moderator

Re: grant privileges for multi_column_datastore [message #128471 is a reply to message #128469] Mon, 18 July 2005 16:45 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
As the error message says, only the CTXSYS user can create that preference.

Report message to a moderator

Re: grant privileges for multi_column_datastore [message #128568 is a reply to message #128471] Tue, 19 July 2005 07:52 Go to previous message
Ragoo22
Messages: 4
Registered: March 2005
Junior Member
However, I have before granted those privileges (i.e. creating preferences, multi_column_datastore) from CTXSYS to a user that I created. I'm not sure if I am recalling the syntax wrong.

Any ideas?

Report message to a moderator

Previous Topic: Image Formats
Next Topic: File store
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 18 11:47:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.