How do i enable ddl so that i can execute a ALTER table command

[theirishmole]

When i try to do an ALTER TABLE command i get the following:

Error: [SQLCODE: <-300>:<DDL not allowed on this table definition>]

How do i enable ddl?

[Thomas Springer]

> When i try to do an ALTER TABLE command i get the following:
>
> Error: [SQLCODE: <-300>:<DDL not allowed on this table definition>]
>
> How do i enable ddl?

I guess this is a permissions problem.
Try to grant the particular user %ALTER privileges on the table. You can
do that by using the SM-Portal. See [Home] -> [Security] -> [Users]

You might want to read more about Caché Security in the documentation:
http://docs.intersystems.com/cache20091/csp/docbook/DocBook.UI.Page.cls?KEY=GCAS_sql

Hth,
Thomas

[theirishmole]

I solved the problem.

I had to put [ DdlAllowed ] in the class definition.

> You might want to read more about Caché Security in the documentation:http://docs.intersystems.com/cache20091/csp/docbook/DocBook.UI.Page.c...
>
> Hth,
> Thomas