GeekArticles
FAQ
Oracle FAQAVOID SELECT TABLES WHEN THEY HAVE SELECT TO PUBLIC GRANT
Author: asktom.oracle.com |
Published: 20th May 2007 |
Visited: 148 times |
Add CommentFiled in: Oracle FAQHi,
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
Related Articles
• 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 ...
• 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 ..........