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.
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.
