SIMs Security for sensitive data
My school has asked me to support SIMS ( updates, new installs etc) which I have done for a long time but I have always used the Bursars login ( yeah I know). Things came to a head when I requested a machine login for our library integration when I was told that I was not allowed on due to the sensitive nature of the data. I pointed out that I have access via the Bursars login but more basically have file level access to SQL Db didn't move anyone so I am wondering if any of you know of a way of passwording certain files or permissions that will preserve data security whilst allowing me to do my work.
Capita were pretty baffled so I thought I would consult some experts....
My knowledge of SIMS is pretty basic but surely there is some granularity to the permissions but not sure where to begin?