Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

DB Find similar branches


andre_polt   (2001-12-04 16:22) [0]

How to display all database objects for a specific user (under Oracle).
For example, all functions and representations for the user "Test".



EAlexander   (2001-12-04 16:32) [1]

SELECT * FROM ALL_OBJECTS WHERE OWNER = "Test"
like so



petr_v_a   (2001-12-05 13:49) [2]

Clarification: this query will list all Test user objects that the current user has access to. All objects that have Test is the owner -
SELECT * FROM DBA_OBJECTS WHERE OWNER = "Test". All objects to which Test has access is not a completely trivial task, see the source code ALL_OBJECTS and replace there ... = userenv ("SCHEMAID") ... with UID Test

Happy Researching :)



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top





Memory: 0.54 MB
Time: 0.023 c
3-21931
SklifF
2001-12-04 15:59
2002.01.08
What is this mistake? Capability not suppoted


1-22212
T2
2001-12-14 03:13
2002.01.08
MMTOOLS CRACK


1-22150
Dimich
2001-12-20 13:22
2002.01.08
How to scroll in Panel


1-22009
oomneeq
2001-12-14 21:26
2002.01.08
Circular class reference


14-22413
RUS
2001-11-11 21:27
2002.01.08
CD-RW





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish