SIFRESINI BILMEDIGIMIZ BIR USERA PROXY USTUNDEN BAGLANMA

1.AMAÇ VE KAPSAM

 

Bir user schemasının butun ozellikleriyle index yapisini cikartmaya yarar.

 

 

2.UYGULAMA

2.1 Sqlplusa sysdba olarak bağlanıyoruz.

 

 

[oracle@localhost ~]$   sqlplus / as sysdba

 

SQL*Plus: Release 11.1.0.6.0 – Production on Thu Jun 17 13:15:53 2010

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

 

2.2 Yeni bir user yaratıyoruz.

 

SQL> create user test identified by test;

 

User created.

 

2.3 Proxy üstünden bağlanacagımız userla yeni yaratmış olduğumuz useri bağlantı haklarını veriyoruz, alter userdan sonra gelen user ismi bağlanmak istediğimiz user oluyor.

 

 

SQL> alter user hr grant connect through test;

 

User altered.

 

2.4 Yaratmış olduğumuz proxyi denemek için sqlplusdan çıkıp tekrardan bağlanıyoruz.Show user komutuyla hangi userla login oldugumuzu ogrenebiliriz.

 

SQL> exit

sqlDisconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@localhost ~]$ sqlplus test[hr]/test

 

SQL*Plus: Release 11.1.0.6.0 – Production on Thu Jun 17 13:17:30 2010

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> show user

USER is “HR”

SQL>

About tayfun inam

Computer Engineer -PostgreSql-Oracle Database Administrator I am about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 8+years experience.I have OCA,PostgreSql senior Certificates I have worked 50+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.

Leave a Reply

Your email address will not be published. Required fields are marked *