apkagame

March 2011

Creating DB User and Grant Option - Oracle

Unknown 03:04

When the new user has been created in Oracle database, the new user cannot do anything with the database. The database admin has to grant privilege to that user. First privilege is

SQL> grant connect to Tommy;

Grant succeed.

The privilege allow the user Tommy to be able to connect to the database. In order for user Tommy to use the resource, granting resource must be follow:

SQL> grant resource to TOMMY;

Grant succeeded.

Now, the user Tommy can use resource like table space. There are other options in privilege to be granted. From my practice, after I create the new user, I also grant EXP_FULL_DATABASE to the user.

SQL> grant EXP_FULL_DATABASE to TOMMY;

This option allows the user to create and drop tables and other objects.

Oracle Password Management

Unknown 23:18

Each user account is protected by the their password. When the user is created, the password is assigned to the user. By default, user password is set to expired by 180 days. After the password expires, the user can no longer access his or her account. To see the expiry date for each open user, user following commands.

SQL> Select username, Account_Status, Expiry_Date from DBA_USERS;

The result shall display after query statement execution. The database administrator can switch off password expiry option by issuing the following command

SQL> Alter Profile Default limit PASSWORD_LIFE_TIME unlimited;

Profile altered.

Now running the same query below, the expiry date value shall be null

SQL> Select username, Account_Status, Expiry_Date from DBA_USERS;

However, this is dangerous for security reason because all users under PROFILE default have non-expiry date for password. To limit the password expiry again,

SQL> alter profile default limit PASSWORD_LIFE_TIME 180;

Profile altered.

180 means password expire after 180 days

Dreams Come True (2010)

AKA: On the Pitch
Revised romanization: Ggumeun Yirueojinda
Hangul: ê¿ˆì€ ì´ë£¨ì–´ì§„ë‹¤
Director: Kye Yun-Sik
Release Date: 2010/05/27
Runtime: 113min
Genre: Drama, Comedy
Language: Korean
Country: South Korea
Imdb link: none

Cast : Lee Sung-jae , Kang Sung-jin , Yoo Tae-ung , Choung Kyung-ho , Lee Seon-ho, Oh Tae-kyung,, Lee Jeong-ho , Choe Sang-hak

Synopsis

When the Korea-Japan World Cup kicks off in 2002, a North Korean squad leader stationed at the DMZ is frustrated that the political situation is preventing him, a football enthusiast, from enjoying the games. One day, the squad comes face to face with their archenemy an armed South Korean reconnaissance squad while they patrol the DMZ border! Tension is short-lived, however, when they find common ground in their mutual football fever.

Eventually, secret radio communications begin, with the South suggesting the North Korean squad listen to match broadcasts with them through radio transmission. But the Frequency Monitoring Team detects the squad's discreet correspondence with the South Koreans. Refusing to get his men involved, the squad leader turns himself in and fearing for their leader's life, the squad devises a plan for his escape.

Download [MF] :

Movie + Eng Subs
Note : Langsung diekstrak saja.

Box

Unknown 09:46 Drama , Japan Movie

Japanese Ttle: ボックス！
Romaji: Box!
Year: 2010
Country: Japan
Director: Toshio Lee
Screenwrieter: Naoki Hyakuta (novel)
Genre: Drama
Runtime: 126 min
Language: Japanese
Subtitles: Japanese
IMDB: http://www.imdb.com/title/tt1564559/
Theatrical Release Date: May 22, 2010

Cast:
* Hayato Ichihara - Kabu
* Kengo Kora - Yuki Kitaru
* Yu Kashii - Youko Takatsu
* Mitsuki Tanimura - Satoko Maruno
* Toshio Kakei - Kantoku Saoki
* Misa Shimizu - Satoko's mom
* Mai Hosho - Kabu's mom
* Mami Yamasaki - Kabu's sister
* Suwa Masashi - Inamura

Synopsis/ Plot

Set in a high school boxing club in Osaka, Kabu (Hayato Ichihara) is a likeable delinquent who cuts up during classes, but works masterfully in the boxing ring. Then one day on the subway, Kabu takes out three thugs who are harassing a young couple. When Kabu gets off the train, he realizes that the man being harassed is his childhood friend Yuki (Kengo Kora), who moved away several years back.

To Kabu's delight he learns that Yuki has now moved back to town and is now attending the same high school as Kabu. A few days later, Kabu insists to the timid Yuki to join the boxing club. After much badgering upon Kabu's part, Yuki finally decides to take up the boxing gloves. Although Yuki is completely new to the sport, he does train with earnest determination.

Meanwhile, a local boxing tournament takes place with Kabu easily going through his opponents. That is until the championship match when Kabu faces the highly feared boxer named Inamura (Suwa Masashi). To Kabu's surprise, Inamura knocks out Kabu. The loss devastates Kabu and he quits the boxing club. Yuki, on the other hand, stays in the club and trains as diligently as ever. When Kabu finally rejoins the boxing club, Yuki and Kabu both train for the next tournament to take out Inamura, but Inamura has a surprise for the two boxers

Download

CD 1: http://www.fileserve.com/file/VZ7Cm25
CD 2: http://www.fileserve.com/file/4nHNkbk
Or
CD 1: http://www.megaupload.com/?d=F4UALWJJ
CD 2: http://www.megaupload.com/?d=5M0TY7C0

IDWS

CD 1
001 | 002

CD2
001 | 002

Alien vs Ninja

Unknown 09:04 Action , Comedy , Japan Movie

Release year.....: 2010
Genre............: Action/Comedy
IMDb rating......: 5.7/10
IMDB Link........: http://www.imdb.com/title/tt1592503/
Language.........: Japanese
Subtitles........: English .srt file ONLY
Runtime..........: 1hr 21mn
Source...........: DVD R2
Ripped with......: Subrip
Frame rate.......: 25.000 fps

Cast : Mika Hijii / Ben Hiura / Shûji Kashiwabara / Masanori Mimoto / Yûki Ogoe / Donpei Tsuchihira
Plot summary

In feudal Japan, a strange flaming object falls from the sky, and when reports of mysterious deaths follow, three ninja warriors are sent out to investigate,brave Yamata (Masanori Mimoto), stealthy Jinnai (Shuji Kashiwabara) and their silly sidekick Nezumi (Donpei Tsuchihira).

What the ninjas find is outside their previous experience.A bloodthirsty creature from another world that has arrived on Earth and plans to kill everything in its path. However, the alien didn't count on the tenacity or the fighting skills of the ninjas, and they set upon the creature with the help of sword-swinging female ninja Rin (Mika Hijii).

Download

http://www.enterupload.com/elffc7ep9jra
OR
http://www.mediafire.com/?1kwjlx81d5jt8k5
http://www.mediafire.com/?l7ujn775hlj27bq

Acoustic

Unknown 08:58 Drama , Korean Movie , Musical

어쿠스틱 (Eo-koo-seu-tik)
Cast: Sin Se-kyeong, Seulong, Lee Jong-hyun, Kang Min-hyuk, Baek Jin-hee, Lim Joon-il
Directed: Yoo Sang-hun
Genre: •Omnibus •Drama •Music
Runtime: 1:27:40
Country: South Korea
Language: Korean
Subtitles: no english subs

Plot

Groups of young musicians in Hong-dae are spreading. While starving because of music, the hope to live off of music can change in a second. This movie draws attention because of episodes of Sin Se-kyeong, CN Blue, and 2AM members.

"Acoustic" is a youth movie about 20-year-olds who look to music for their hopes, dreams, and love. Sin Se-kyeong will play a vocalist who has a rare disease that requires her to eat only ramyun. Seulong partners with Baek Jin-hee to become an awkward but lonely boy and girl. Also, Lee Jong-hyeon and Kang Min-hyeok from CN Blue play a drummer and a guitarist who enter a new music world after meeting a bakery owner.

Download

http://www.megaupload.com/?d=M9QSLO50
or
http://www.fileserve.com/file/EqYjufg

Mirror Mediafire, split 7 part

http://www.mediafire.com/download.php?811vzz62aei8te1
http://www.mediafire.com/download.php?qovgsyyvhv8z4wq
http://www.mediafire.com/download.php?5izaed2a62afb4i
http://www.mediafire.com/download.php?bx6fxl2hcj6flv1
http://www.mediafire.com/download.php?opph826dmrjtcm5
http://www.mediafire.com/download.php?bxyww6o8ar8a4pp
http://www.mediafire.com/download.php?kkdpd3o0mslfpwj

MF pass: idws

CRC(optinal): http://www.mediafire.com/download.php?tqg5tijq94ggh2f

A Stranger of Mine ~ Unmei Janai Hito

Unknown 08:35 Comedy , Drama , Japan Movie , Romance

Akka: Unmei janai hito

Year - 2005

Directed - Kenji Uchida

Genre - Comedy / Drama / Romance

Run Time - 98 min

Country - Japan

Audio - Japanese

Subtitles - English [hardsub]

IMDB Links - http://imdb.com/title/tt0461857/

Cast: Yasuhi Nakamura || Reika Kirishima || S. Yamanaka || Yuka Itaya

Plot:

"In one long Friday evening, Takeshi Miyata, a straight-arrow businessman, will encounter a number of people (some only fleetingly) who have intertwining fates. After six months he is still mourning the loss of his girlfriend, Ayumi and is lured from his apartment when his childhood friend, the detective Yusuke Kanda, telephones invoking Ayumi's name. Arriving late at the appointed restaurant, Kanda says Ayumi is getting married and chides Miyata over not finding a new girlfriend.

He then spontaneously invites a solitary diner, Maki, to join them. Although she is silently vowing to be alone because of bitterness over her engagement being broken just the day before, she quickly agrees. Kanda makes a sudden exit, leaving his friend to contend with the despondent and homeless girl.

The two return to his apartment, but as Ayumi appears wanting some of her things she left behind, Maki says she must leave. Meanwhile, Miyata remains oblivious to the fact that both Kanda and Ayumi are being threatened by Asai, a Yakusa mob boss, and his mob over the disappearance of the "money" from Asai's safe.

DOWNLOAD (Hardsub)

Oracle Password Restriction & Solution

Unknown 02:49 database administration , Oracle

What are valid characters in password for Oracle? The Oracle recommends using the combination of letters and numbers. Symbols of "#", "_", and "$" sign are also valid. There are rules that you should follow when creating the password.

First Rule: The first letter of the password must start with the letter, Example

SQL> alter user tommy identified by tommy1234;

User altered.

SQL> alter user tommy identified by 1234tommy;

ERROR at line 1:

ORA-00988 missing or invalid password(s)

As you can see, the password cannot start with the number. However if you want to start password with the number, you can use the double quotation mark on the password;

SQL> alter user tommy identified by "1234tommy";

User altered.

My note: some blogs say password is not case sensitive. I do some testing on the testing database. The result is password is case sensitive. If your user password is Tommy1234, typing password as tommy1234 gives the error message while logging in.

Good luck........

Alter User Password - Reset User Password in Oracle

Unknown 01:34

When the database administrator creates a new user in the Oracle database, password for the new user is set to expire. Password expiry occurs, for it is the default in setting inside Oracle. You can query the Oracle database to see the detail of the database profile as:

Select Profile, Resource_Name, Resource_Type, Limit

from dba_Profiles

where Resource_Name like 'PASS%';

Then, look for highlight line. The password expire after 180 days.

Then, you can query the DBA_USERS table to see the expiry date for the user. Using the follow SQL statement:

Select UserName, Account_Status, Expiry_Date

from dba_Users

Where UserName = 'TEST';

The above query will show the account status and password expiry date for user TEST.

The password for the user TEST shall expire on Sep 03, 2011. What happen when your user password expires. The user cannot log in. Let's try by altering the user TEST account status to expire. Log in the Oracle database as SYSDBA in SQL Plus, and issue alter statement as follow:

Alter User TEST Password Expire;

Now the user TEST shall not be able to connect to the database. Here is the result after altering password to expired