Link to home
Start Free TrialLog in
Avatar of gtrapp
gtrapp

asked on

Need to grant a user access to ALERT or change a table

I am having problems granting a user permissions to grant access to ALERT or change a table.

I have this, but it does not allow the user to alter or change the table:

grant select, delete, update, insert on cf_pbtf_test.ASSISI_YIELDS to AssisiCengeaTest

Any advice on how to make this happen?
Avatar of Emes
Emes
Flag of United States of America image

The user mu t be the owner of the table.

You need to place the user in your (owner) groups
Avatar of gtrapp
gtrapp

ASKER

Can I place the user in the owner group, but only give the user access to change selected tables?
ASKER CERTIFIED SOLUTION
Avatar of Emes
Emes
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gtrapp

ASKER

If run that command, do I still need the following?

grant select, delete, update, insert on SalesTable to TestUser

Seems like the TAKE OWNERSHIP would override "select, delete, update, insert" options.
that should do it he is now an owner
Avatar of gtrapp

ASKER

The cf_pbtf_test is the database name.