Skip to content
+1-888-319-3663

COMMUNITY FORUM

sysadmin

doncomon asked 7 years ago
SmartConnect is installed and working at one of my clients, but the DBA doesn't want the SMARTCONNECT user to have sysadmin rights. Does that user have to have it after the install has already been done? Is there any need for normal use of integrations to have the SMARTCONNECT user having those rights? If not what rights would he need now. I can't remember if adding new users in SmartConnect is done through that users rights or not.

Thanks,

Don C
Answers
Best Answer
Lorren answered 7 years ago
Don,

The SmartConnect user does not have to have sysadmin rights.  Make the SmartConnect user the db_owner of the SmartConnect database.

Lorren
doncomon replied 7 years ago

Thank you.


If you would like to submit an answer or comment, please sign in to the eOne portal.