I am sorry for my poor English.
I use SQL SERVER 7 and MDAC 2.6.
I have a DB named Manage, and there are three table, userinfo, resource and product, in it.
How to use SQL query statement to add a user into the DB, and grant the user in the userinfo, resource and product table?
For example, I want to add a user Jerry to the DB, and grant Jerry to the tree table with selecting, updating and deleting.