SQL Server security

njcncadmin

Active Member
Happy new year,

I was wondering if anyone has changed the default security for a JDE/SQL Server install. By default, public is granted full access to the JDE database tables. We have a need to have external users access the JDE database tables without using ODBC, ODA, etc. I wanted to create a read-only userid, but all users are added to public, so any new userids are granted full access.

As a temporary fix, I created a jdeuser and externaluser role in the database. I added all the JDE delivered userids to jdeuser, revoked full access from public, and then granted full access to jdeuser. For the externaluser role, I granted the db_datareader role. This is semi-acceptable, but all newly created tables are giving full access to public.

Any ideas? Thanks.
 
Back
Top