I am using Personal Oracle 7 for Windows and Oracle Power Objects version 1
With the users editor I've created a ROLE called superuser, to which
I've assigned all database priveleges for the standard database.
I've also created several users, including myself.
These users I have assigned the ROLE of superuser.
I then used the object manager to created a new table, calling it
EDISON1. I, of course, have full priveleges, since I'm its owner.
I've also assigned full priveleges for this table to the superuser role.
This should, in effect, give all users with the superuser role, full
access to my table, correct?
It's not working that way.
If I run SQLPLUS, log in as myself, and type
describe edison1
I get a description of the field names and their definition.
If I log in as anyone else who has superuser role, the above SQL command
returns an object not found error or something.
The same happens with Power objects.
I've created a new session. WIth the connect script as:
Oracle:myuserid/mypassword
Activating the session lets me see my table, edison1.
If I change the connect string to the userid/password of
any of the user superusers, I can't access my table.
The question is: why aren't access priveleges working?
If instead of granting table priveleges to a role, I grant them directly to a
user, that user still cannot access my table.
No matter what I seem to do, no one besides myself can access my table.
Can someone help?
Jeff McWilliams
--
Jeff McWilliams -->classic Atari black-hole resident.
cd827_at_cleveland.freenet.edu
