User Role Required for New Table??

Jonathan102
Tera Guru

‎06-22-2023 01:55 PM

Why is a user role a required field on a new table?  We want everyone to have access to this table, how can we accomplish this task?  I tried creating a read ACL with no requirements, still didn't work.  I know some tables, like sys_user, are available for all users to view.

 

Thanks,

Jonathan 

0 Helpfuls
  • 1,061 Views
1 REPLY 1

Tony Chatfield1
Kilo Patron

‎06-22-2023 02:16 PM

Hi, a new user role is not required for each new table, but it is the default SNC setting when creating a table;

You can utilize existing ACL's, although this is only really viable if you are extending an existing table as the base line ACL's are very generic.
During table creation navigate to the 'Controls' tab and remove the flag form the 'Create access controls' tick box, a new role and ACL's will not be created. If you leave this enabled during creation, but decide you do not want to use the new role and ACLs, you can simply set the ACL's inactive.

if creating a table via Studio, I think you can just skip the role creation section by clicking next.

0 Helpfuls