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!
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.
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?
Previous Topic: Image Formats
Next Topic: File store
Goto Forum:
  


Current Time: Thu Mar 28 17:34:28 CDT 2024