HELP--removing PUBLIC from one user
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Sat, 17 Sep 94 09:52:00 -0500
Message-ID: <12a.4926.905_at_compudata.com>
Date: Sat, 17 Sep 94 09:52:00 -0500
Message-ID: <12a.4926.905_at_compudata.com>
-> Oracle has a dozen or so tables with PUBLIC access (e.g.
-> public.form_blk, public.form_page, etc.) I want to block the access
-> of these tables to one user but keep the PUBLIC access to all other
-> users.
->
-> I don't want to have to go thru all of these tables dropping
-> the public access and re-granting the access to all but this user.
-> Any suggestions?
->
-> (Why am I doing this? Because PowerBuilder displays all of these
-> tables when a data window is created and it's getting to be a pain
-> when I am building a lot of new data windows.)
Howsabout create view for the datadictionary that PowerBuilder is qierying for table names, and exclude these from that view? Received on Sat Sep 17 1994 - 16:52:00 CEST