Access Error

Database
Enthusiast

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
Junior Contributor

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
Enthusiast

Re: Access Error

Hi Dieter, Thanks a lot.