How to Handle new users in this senerio...

From: <tim_mcconechy_at_my-dejanews.com>
Date: Thu, 20 May 1999 11:14:27 GMT
Message-ID: <7i0qqj$nbb$1@nnrp1.deja.com>

Hi...
I have the following scenario...
A user sysadm owns everything in a schema. tables,Sequences,triggers,procedures...

A new user is added and needs access to all of sysadm's objects.

Code says "select * from users" for example. Not:
"select * from sysadm.users"

My thought was..
create public synonyms on all objects;
grant select,update,delete on all objects to public...

But isn't there an easier way???

I am just a little confused and wondering what people would do in this scenerio.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 20 1999 - 06:14:27 CDT