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

johndanter

johndanter

Legendary Poster
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
 
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.
 
Hi, yes that's what I mean.
The script seems like a good idea :) Thanks
 
Back
Top