You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

data mover

1 reply [Last post]
Guest's picture
Guest

i have two tables.i want put all privileges on one table to another table that means which roles and users have privileges to one table should have same privileges on another tables.is there any data mover command for that and also pls tell sql command(procedure) for that one.
thanks in advance

CompShack's picture
User offline. Last seen 6 years 8 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: data mover

You can grant users various privileges to tables by using the "Grant" command. Just check what Grant Privileges are on table1 and Grant them to table2, you don't need data mover for that.

The syntax for granting privileges on a table is:
grant privileges on object to user;

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog