Tuesday, September 14, 2010

For Reference- Sysdba priviledge to any user

For any user to have sysdba priv:

1) Oracle maintains an encrypted password file, which has entries of all the users who have SYSDBA privilege. This file is located in $ORACLE_HOME/dbs location. In order to create password file, orapwd utility is used:
orapwd file=[file_name] password=[sys pwd] entries=[max entries of users in passwordfile]

2) show parameter remote_login_passwordfile
  • EXCLUSIVE - Password file would be exclusive to this DB instance.
  • SHARED - Password file can be shared to multiple databases

3) select * from v$pwfile_users - Since the password file has been freshly created, the view v$pwfile_users would have the entry of SYS user only.

4) grant sysdba to [user]

5) select * from v$pwfile_users - would display the [user] as well.

The [user] would be added to the entries in the password file, and hence would have sysdba privs.
Password file is used only when the user tries to connect a database from remote server. The other way to connect to the database is .. OS level authentication, wherein the user logs in to the database from the same server where the database resides.
sqlplus dsingh as sysdba - Oracle uses OS level authentication.
sqlplus "dsingh@w140p.world as sysdba" - Network authentication
(Also, in case of OS level authentication, whatever follows sqlplus is ignored. If the current logged in user is a part of dba group, it would be allowed to login as sysdba. )

Saturday, September 11, 2010

One year's trash...

Happened to clean my room today.
With piles of papers stacked together, its hard to keep track of what is where. Our very own room becomes so unknown! And the day we need something, unfortunately there is no CTRL+F option to make our life easier!
So, today i thought of putting things back in place. Believe it or not.. I managed to collect 5 big polybags of trash.. out of my room. Some old unknown bills, shoes, bags, accessories.. There were things about which i had no idea.. courtesy my poor memory. And few, which had some incidents attached to it..which were equally trash. Some of them also reminded me of my unfulfilled dreams.. and unimplemented plans.

Removing trash out of my room, was a walk over to what all i did last year. Most of them were things which mean nothing to me anymore.

I hope that i dont accumulate any more trash in my room.
Hope i dont lift another dream to dump it to dustbin again.

Friday, September 10, 2010

Sallu Bhai ki jai !!!

Watched 'DABANGG' today..!!! A classic example of mast mass movie.. Absolute trash with every possible mirch masala.. made to be a HIT for sure!! At times i pity salman khan. Old age, hair loss and on top of it.. rajnikant style action. I still remember his good golden days..the heart throbbing young prem of maine pyaar kiya and sameer of hum dil de chuke sanam.
Salman Khan is a star for sure!! A BIG name in the industry with some really good movies like Khamoshi in his kitty. After being in the industry for so long and building a niche of his own, how can he landup doing an absolute mass movie, with NO brains at all ?? Nevertheless, the reason why DABANGG is a hit is only him.. Only HE can manage to do heights of stupidity with a style of his own and make people just go crazy about it!
Its surely not easy to make a fool of oneself. Salman Khan is doing good in proving himself to be one!

Thursday, September 9, 2010

Coming back after long..

Logged into my blog today.. and saw the last post. I very well remember the time when I started writing this blog. The memories flashed.. and then just got my eyes on the date on the top left corner. Goodness !!.. Its been an year now! This blog seems to have stuck in 2009..which was not a very great year for me in few respects. Nevertheless there were really good things that happened as well ! The best thing being me getting my first job!!, which i cherish a lot. Now its time to give some life to this blog again!
Get going dear.. !