You do not have security privileges to set up external users
Lou Spevack asked 5 years ago
I am getting the error: You do not have security privileges to set up external users when i try to open the SmartView external user setup window. I have the Power User role. Why am I getting this message and how do I resolve it? Thanks.
Answers
Patrick Roth Staff answered 5 years ago
Lou,
This window is creating SQL Logins for the External SmartView users. So the GP user you are logging in needs to be able to create those logins.
The only role that SV is looking for is that the current GP user is a sysadmin (sa or otherwise) in order to create SV External users.
This window is creating SQL Logins for the External SmartView users. So the GP user you are logging in needs to be able to create those logins.
The only role that SV is looking for is that the current GP user is a sysadmin (sa or otherwise) in order to create SV External users.
Lou Spevack replied 5 years ago OK. But I do have the sysadmin role. What permission am I missing to open that window?
Lou Spevack replied 5 years ago I do have the sysadmin role. And the issue is not creating users. It’s opening that window. Thanks.
Patrick Roth Staff replied 5 years ago “You” might have the sysadmin role in SQL but the user that you are logged into GP does not. That is the only reason why you would get this error message.
Patrick Roth Staff replied 5 years ago You can double check this by logging into GP as the ‘sa’ user and you will find that it does work ok because the ‘sa’ user is sysadmin fixed role in SQL.