Grant select on view...
Posted on 2008-11-04
Sybase ASE 12.5
sp_addlogin ahoor, password, dbase1
create view vw_test
select * from dbase2..table1
grant select on vw_test to ahoor
-> login as ahoor
-> select * from vw_test
-> error: user ahoor is not a valid user in database dbase2.
I think this is strange. You create a view in a different database but to use it you still have to copy the users from database 1 to database 2? What is the purpose of creating a view if you still have to do that?
Or is there a way to use aliasses or whatever to get around this?