• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

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?
0
gtrapp
Asked:
gtrapp
  • 3
  • 3
2 Solutions
 
EmesCommented:
The user mu t be the owner of the table.

You need to place the user in your (owner) groups
0
 
gtrappAuthor Commented:
Can I place the user in the owner group, but only give the user access to change selected tables?
0
 
EmesCommented:
You can grant users full rights on certain tables by

GRANT TAKE OWNERSHIP ON [SalesLT] TO [guest]
GO
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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

Is cf_pbtf_test indeed the schema name or is it the database name...cf_pbtf_test.dbo.ASSISI_YIELDS
0
 
gtrappAuthor Commented:
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.
0
 
EmesCommented:
that should do it he is now an owner
0
 
gtrappAuthor Commented:
The cf_pbtf_test is the database name.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now