Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> Transact-SQL

granting select permission

Hi,

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.

[260 byte] By [Doubt_in_sql] at [2007-12-17]

«« Splitting multibyte variables
»» Problem in browsing cube and dimension data

# 1

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.

UmachandarJayachandran-MS at 2007-10-6 >

top of Msdn Tech,SQL Server,Transact-SQL...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified