Database Administration (MOSC)

MOSC Banner

problem with comand

edited Jun 28, 2009 8:07PM in Database Administration (MOSC) 14 commentsAnswered ✓
 

In a table on database ,   I have the comments of the columns of data base , so I like to pass this comments  to the database comments so  I use the EXECUTE IMMEDIATE  comand like this :

where tabacampo  is string that for example coudl be :  compania.id_compania  and

      comentario   is the comments thats I like to add  on table... the problem is I think the command is ok

but I don´t Know  why  I have and Error That is : Ora-01031 Insufficent privileges 

I have to bring a privileges to to User ..... another different like dba privilege ???  

v_sentencia := 'COMMENT ON COLUMN '

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center