sybase privileges grant from one shcema to another -

i have 2 schemas database1@server , database2@server.

i want know how grant priveleges database2 read database1.

example executing in database2:

select * database1..table1 

you have make sure user in database2 added database1 (sp_adduser or sp_addalias).

you can find current user doing select user_name() , list of users within database executing sp_helpuser in database.

assuming have db_user1 , dbuser2, add alias this:

use database1 go sp_addalias db_user2, dbuser1 go 

from point forward, when db_user2 accessing database1, db_user1's credentials, rights , privileges.

if add user, instead of adding alias, have grant privileges tables in schema user (or group user member of).