Skip to Content
0
Mar 26, 2014 at 08:31 AM

How to restrict the user from creating table in any schema using hdbdd

49 Views

Hi Folks,

Problem Description: (Rev 68)

I have "CREATE ANY" access under Schema X and do not have any access under Schema Y.

When am using HDBDD file to create tables. If I mention @Schema : 'Y'. The file gets activated and it is creating a table under Y. ( Even though I do not have access for Y)

Am guessing this behavior is because _SYS_REPO is the user creating the tables up on activation and may be because it has access to those schemas it is creating.

Is there a way to control this behavior to avoid creating the tables under schemas which we do not have access using hdbdd?

Regards,

Krishna Tangudu

Message was edited by: Tom Flanagan