I have a global production server and database, as I all users should have access to it by remote desktop.
Is it possible to grant NTFS permission on all database files (mdf+ldf files) to all users? something like
everyone can full access to it.
note that : we didn't need to share anything by file sharing service.
our app admins can remote and then if needed they all can detach-attach all database if they want. then they want to move or change location of mdf or ldf if they want
my suggestion is we can grant full access to system server admins.
but our dba said:
we grant permission to everyone and it didn't have any risk
is this safe?