Access Error

Database
N/A

Access Error

Hi All,

I´ve a DB "Source" with After Journal, and other DB "Target" without Journal.
My User have Select on "Source" and Create Table, Select, Insert, Delete on "Target"

When try to execute "CREATE TABLE Target.mytable AS Source.mytable WITH DATA" in TD13.0,
recieve the error : [3523] The user does not have INSERT access to Source.Journal

Thanks.

2 REPLIES
N/A

Re: Access Error

CREATE TABLE AS seems to copy the journal definition, too.

Try
CREATE TABLE Target.mytable, NO JOURNAL AS Source.mytable WITH DATA

Dieter
N/A

Re: Access Error

Hi Dieter, Thanks a lot.