Title: access to oracle $ tables in 9.2.0
Try sys.user$
I only have 9i databases, thus cannot
check to see if there were synonyms created in 8. Perhaps this is where the
problem lies?
Eric
-Original Message-
From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL
I believe you need SELECT_CATALOG_ROLE now. Also, the sys priv SELECT ANY
TABLE will not show you the DBA views.
Adams, Matthew
From the Reference Manual:
For example, if O7_DICTIONARY_ACCESSIBILITY = false, then the SELECT ANY TABLE
privilege allows access to views or tables in any schema except the SYS schema (data
dictionary tables cannot be accessed). The system privilege EXECUTE ANY PROCEDURE
allows access on the
SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY, I believe it changed in 9i
and it's documented in the Administrator's Guide, Managing User Privileges
and Roles, Accessing Objects in the SYS Schema.
At 11:49 AM 3/5/2003 -0800, you wrote:
Previously, an account with the DBA role could
directly
Title: RE: access to oracle $ tables in 9.2.0
O7_DICTIONARY_ACCESSIBILITY was an init parameter as far back as 8.0, but in 9.0 and above the default has changed to FALSE instead of TRUE. Which is why, by default, you cannot read any table owned by SYS.
System privilege SELECT ANY DICTIONARY
Title: access to oracle $ tables in 9.2.0
Matt,
It's still valid in 9.2.0.2. Perhaps you need to
qualify the seg$ with SYS schema:
SELECT * FROM SYS.SEG$
HTH.
Arup Nanda
- Original Message -
From:
Adams,
Matthew (GECP, MABG, 088130)
To: Multiple recipients of list
Adams, Matthew (GECP, MABG, 088130),
Hi, a simple test on 9202 tell me I do it:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL create user abcd
Oops. Too fast with the trigger. SELECT_CATALOG_ROLE only gives you
access to the DBA views.
Adams, Matthew
Access 97 Developer's Handbook by Litwin, Getz, and Gilbert. They also make an Access
2000 and 2002 book.
Be careful as there is a Microsoft book by the same title and it's, well, written by
Microsoft. 'enuf said.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Can you please guide me how to do all these steps?
Roland
MacGregor, Ian A. [EMAIL PROTECTED]@fatcity.com den 2002-01-24 08:15 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Whose ODBC DRIVER are you
Whose ODBC DRIVER are you using? If it is Microsoft's ,go to the workaround options
for the DSN; once there, turn of muti-threaded server support.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 24, 2002 4:55 AM
To:
Somewhere at otn.oracle.com is an Access migration kit for Oracle.
It's been awhile since I've looked at it, but it's still there.
If you need to have several LONG types in a table, you will need
to use BLOB or CLOB instead of a LONG.
You don't really want to use a LONG datatype anyway, as
Michael - This was discussed in detail recently on this list. Basically,
what I recall is:
- The key is to define the tables in Oracle first, then import your
Access data. You don't want to let Access define the tables, and I think you
are learning this.
- How large are the Memo
13 matches
Mail list logo