Database user permissions - MS SqlServer
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.