Bazen bir user’ı drop etmemiz gerekir. Drop ettiğimiz userı her hakkı ile tekrar yaratmak gerekecek ise user drop etmeden ddl scriptlerini öğrenebiliriz. Bu ddl tekrar çalıştırarak aynı user ulaşabiliriz.
select dbms_metadata.get_ddl(‘USER’, ‘&&username’)test from dual;
select dbms_metadata.get_granted_ddl(‘OBJECT_GRANT’, ‘&&username’) test from dual;
select dbms_metadata.get_granted_ddl(‘ROLE_GRANT’, ‘&&username’) test from dual;
select dbms_metadata.get_granted_ddl(‘SYSTEM_GRANT’, ‘&&username’) test from dual;
About oracledocuments
Zekeriya Beşiroğlu, It joined the Bilginc IT Academy in July 2000. In the meantime, the Oracle Education, Oracle Data Base Management System and Oracle Internet Technologies, Oracle development technologies such as the training of Oracle products is responsible for training as consultants. During this task, since 1 April 2008 with 293 Oracle training in total, in 2150 Oracle customers successfully submitted. Oracle 10g New York in November 2002 have received training and education in Turkey was the first time the consultants. 20 April 2008 on education in Turkey 11g is the first who was a consultant. Oracle Real Application Cluster Expert advisor is certified is the first . Http://zekeriyabesiroglu.blogspot.com and Http://www.oracleforum.info owner and manager of the site. Its own has more than one hundred articles. In addition, creation and improvement of training materials are also related to work. Oracle products are used, database management and reporting Academy eruditely It also is working on. From the date of 1 January 2009 will continue to work as the Technical Director
This entry was posted in Uncategorized and tagged
drop user geri getirme. Bookmark the
permalink.
Oracle Documents / Zekeriya Besiroglu 