DB Grants

riccardob

Certified Lead Developer

over 7 years ago

Hi all,

I'd like to know which kind of grants do we need to configure for the db users to use for both Primary and Business datasource: should they be dba or users with a simple one with the right grants? If so, which grants?

I'm working on an Oracle db.

Thanks,
Riccardo

Discussion posts and replies are publicly visible

0 kumara778 over 7 years ago

You need to be part of database administrator to access Primary DB and for Business data source you need provide access to that DB alone
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 7 years ago

The DBA roles sounds a little heavy handed. Your actual DBA's might be happier with the "resource" role being applied to the users
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riccardob
Certified Lead Developer
over 7 years ago

Thanks for your answers kumara778 and tim.clarke.
So, by default, users' role RESOURCE would be enough on both primary and business datasources?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 7 years ago

forum.appian.com/.../DBMS_Integrating_Appian.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riccardob
Certified Lead Developer
over 7 years ago

Thanks Eduardo, this was helpful
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel