How to grant select permission on table of another database from current database.
Ex: I am in database asddb
I want to grant select permission on table "test" which is in database bsddb.
Can anyone please help me in resolving this problem.Please take a look at the GRANT statement in Books Online. You need to switch to the database using USE and run the GRANT statement.
No comments:
Post a Comment