New custom table - security privileges. where does E1 get it from

[johndanter]

Hi guys,

If I build a new sys 55 table in E1, where does E1 get it's default user security settings from at the schema level?

Thanks

John

 

[Larry_Jones]

John,

do you mean what default Database security permissions are assigned?

To my knowledge none. New tables are wide open. Public access.

Hopefully someone else knows how to change this default?

Our practice here is to periodically run a script that strips Public access from JDE tables and assigns access to a JDE DB Role.

 

[johndanter]

Hi, yes that's what I mean.
The script seems like a good idea Thanks