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?
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
Any advice on how to make this happen?
ASKER
Can I place the user in the owner group, but only give the user access to change selected tables?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
ASKER
The cf_pbtf_test is the database name.
You need to place the user in your (owner) groups