I'm being advised that the sysadmin role is required for all users if Field Level Security is to work in GP.

(0) Share

Report

Posted on by David Burcul

I inherited a GP database and all GP users had sysadmin permissions on the SQL Server, after research and talking with our developers there was no reason known to keep this level of access. sysadmin permissions were therefore removed leaving user accounts with the default SQL Server GP permissions and membership to the DYNGRP role.

It has just been found that we have Field Level Security enabled and the removal of the sysadmin permission on the SQL server has caused issues, and field level Security no longer works.

Can anyone advise on permission required for Field Level Security to function correctly? Surely all users do not require 'god' permissions, i suspect our developers are not telling use the whole story and would like unbiased input.

Cheers,

Dave

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Jason Chung 1,110 on at

Like (0)

Report

I am missing a whole lot of info concerning your environment to conclude anything. So all I can say, is that I've been using Field Level Security for years and NEVER have I needed to grant sysadmin to my GP users for FLS to work properly.

Hope this helps,

Jason

Was this reply helpful? Yes No