Hello everyone!
I have been making my project in database for study.
Yesterday I made something or something has been made itself, so i couldn`t access with my user account to any object belongs to his schema via sql console. But outside the user, e.g from SYS account or by application using my user`s schema I could read tables of my user.
-----
I`m uisng (SELECT * from v$version;)
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Application Express 2.1.0.00.39
I have Vista installed.
-----
Lets some exapmle of this trouble. (my usera has name DYREKTOR)
(via user dyrektor - he creates table dni few weeks ago)
SELECT * from dni;
ORA-01403: no data found
via (user SYS)
SELECT * from dyrektor.dni;
ID_DNIA
CZW
PON
PT
SR
WT
5 rows returned in 0,01 seconds
I couldn`t make any sql command via user DYREKTOR:
(via user dyrektor)
SELECT * from ALL_DIRECTORIES;
ORA-01403: no data found
(via user dyrektor)
dbms_output.put_line('test');
ORA-20000: User DYREKTOR has no privileges on the schema.
Does the error be like :
ORA-20000: User DYREKTOR has no privileges on the HERE_NAME_OF_SCHEMA schema. ?
-----
select object_type,count(*)
from dba_objects
where owner = 'DYREKTOR'
group by object_type
order by object_type
OBJECT_TYPE COUNT(*)
FUNCTION 1
INDEX 15
PROCEDURE 13
SEQUENCE 1
TABLE 20
TRIGGER 2
-----
As i mentioned, I could do operations on tables and procedures from schema DYREKTOR in apllication mady in application builder
-----
Whats about grants ? Before my problem occurs, i didn`t modyfied grants. After I check the grants of DYREKTOR - its looks like stay the same they are before (roles dba, connectm resource) - I check it on the
Administration->Manage user account page.
It looks like it was in schmea name for user DYREKTOR
Problem occures why I was writing new procedures (using utl_file for write file and dbms_output.put_line)
----
EDIT 29.05.2010 12.10*
OR problem occurs after i tried to delete some entry form table all_directories and I make a little mistake. I have entrres TMP and INFO_DIR. I would delete the TMP but i wrote
delete from all_directories where DIRECTORY_NAME = 'DIR'
. Could it be the problem source ? Shall I give any details from files in *dump directories ?
END EDIT
-----
Have anyone any idea ?
I hope i described my problem clearly. I could give any further details.
Thanks for anu sugestion for solving my trouble.
(Next week I should do presentation of my project, I like to improve some procedures, but i could`nt do anything)
PS. Sorry for my bad english.
Edited by: user13174576 on 2010-05-29 03:04
Edited by: user13174576 on 2010-05-29 03:10