Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!zaphod.mps.ohio-state.edu!rpi!uupsi!sunic!ericom!etxstwi
From: etxstwi@juno.ericsson.se (Stefan Wikstrom TM/JUF 7191288)
Newsgroups: comp.databases
Subject: Sybase grant problem
Message-ID: <1990Oct11.164712.9544@ericsson.se>
Date: 11 Oct 90 16:47:12 GMT
Sender: news@ericsson.se
Distribution: comp
Organization: Ericsson
Lines: 22

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. What I have been doing is:

 GRANT SELECT ON myowntable TO user2

When user2 tries to select myowntable error message 208, level 16,
state 1, is displayed, "Invalid object name 'myowntable'."
We are both using the same database.

When issuing the stored procedure sp_helprotect on user2 the grant on
SELECT for the table is displayed.

select object_id("myowntable") gives NULL for user2. However the opposite
action select object_name(id-number) gives "myowntable".

I have been using the db-library, isql and dwb when issuing the SELECT
statement and none have worked.

Can someone enlighten me on this problem?

/Stefan