CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Database user permissions - MS SqlServer

edited Dec 10, 2018 4:06AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

Hi,

DB IT security team is asking for a list of users with the privileges that they need (SqlServer). Do you have a document with that information or somethin that could help for presenting to the team?

They need a document or information from the vendor not from me.

For example, we need information like this:

USER ---------------- PERMISSIONS ------------- WHICH DATABASE

=============================================================

DB user JDE needs select, insert, update, delete permissions for all tables on all databases.

DB user JDEPROXY needs select, inssert, update, delete permissions for all tables on all databases.

DB user PRODDTA needs create Tabñe/Index, drop table/index, create trigger, alter table, on its JDE_PRODUCTION database.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center