AVOID SELECT TABLES WHEN THEY HAVE SELECT TO PUBLIC GRANT

Author: asktom.oracle.com | Published: 20th May 2007 | Visited: 148 times | Add Comment
Filed in: Oracle FAQ

Hi, I have five diferents schemas, every one has tables, but some tables have SELECT TO PUBLIC grant; I have to create an user and this user must be able to access only twelve tables, my problem is that when I create the user it has access to the o...

Read Article

Sponsored Links

• Partitioning existing tables I am attempting to partition a Table T1 with existing data. Table T1 is as follows: COLUMN DATATYPE ----------------- COLUMN1 NUMBER PK COLUMN2 NUMBER COLUMN3 NUMBER I am using this approach: 1- ALTER TABLE T1 RENAME TO T1_TEMP 2- CREA ...

• Querying SQLServer tables from within an Oracle session Dear Tom; I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like: <CODE> select * from t@sql_server_link </CODE> May you redirect me to the appropriate documentati ...

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

• ODP.NET - Populating a Dataset with Multiple Data Tables ODP.NET - Populating a Dataset with Multiple Data Tables Now, let us add more than one data table into a dataset The following code retrieves a list of department details into a data table named Departments and another list of employee details into a data table named Employees: Visit http://www.exf ...

• Partitioning tables with unequal partitions. Hi Tom, We have data coming into our application from different entities/agencies and being loaded into several different tables. Each transmission contains data that belongs to a unique entity. We can also receive a new transmission for each ent ...

• dml single insert/select or bulk collect/forall Tom, i am currently designing a new database 10g Rel2 and would appreciate your advice on the following Which method would you advise for the following business process OPTION 1 ######## DECLARE CURSOR c1 IS SELECT ..........

• The easy route to tables, rollovers, and links View a series of video tutorials to learn how to lay out tables, create rollovers and links, and preview pages in GoLive ...

• Customize the built in Outlook Select Names Dialog (or any other) In this article you will learn how to customize the built in Select Names Dialog and use different external Datasources for your own Di ...

Next: Colums into rows