Path: utzoo!attcan!uunet!know!sdd.hp.com!ucsd!ucbvax!mtxinu!sybase!jeffl@sybase.Sybase.COM
From: jeffl@sybase.Sybase.COM (Jeff Lichtman)
Newsgroups: comp.databases
Subject: Re: Sybase grant problem
Message-ID: <11296@sybase.sybase.com>
Date: 13 Oct 90 23:01:28 GMT
References: <1990Oct11.164712.9544@ericsson.se>
Sender: news@Sybase.COM
Distribution: comp
Lines: 14

> I have not been able to grant select, or any other access permissions for
> a table owned by myself to other users in Sybase and I cannot see why it
> shouldn't work.

To select from a table you don't own, you must specify the owner:

	select * from user1.myowntable

The only exception is when the table is owned by the dbo.  You do not
have to specify the owner to see a dbo table.
---
Jeff Lichtman at Sybase
{mtxinu,pacbell}!sybase!jeffl  -or- jeffl@sybase.com
"Saints should always be judged guilty until they are proved innocent..."