Home » SQL & PL/SQL » SQL & PL/SQL » login comand (merged)
icon4.gif  login comand (merged) [message #377620] Tue, 23 December 2008 23:43 Go to next message
CLS63AMGV8
Messages: 11
Registered: November 2008
Location: Oman
Junior Member
hi all
how are you
I need help please
I'm new user in oracle
I want to create user name and password and i need the comad for pl/sql
and i created login table. user_name is 42278 and password is fdg456
Re: login comand [message #377628 is a reply to message #377620] Wed, 24 December 2008 00:11 Go to previous messageGo to next message
dvishnu_apps
Messages: 34
Registered: September 2008
Member
The Syntax for creating user is:

create user <<USERNAME>> identified by <<password>>

This statement is to be executed as SYS user.

Re: login comand [message #377631 is a reply to message #377620] Wed, 24 December 2008 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
CREATE USER

Regards
Michel
Re: login comand [message #377632 is a reply to message #377628] Wed, 24 December 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dvishnu_apps wrote on Wed, 24 December 2008 07:11
This statement is to be executed as SYS user.

NO!
This statement has to be executed by a DBA (or one who has CREATE USER privilege), not by SYS; SYS is for database maintenance.

Regards
Michel

Re: login comand (merged) [message #377711 is a reply to message #377620] Wed, 24 December 2008 07:57 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
CLS63AMGV8 wrote on Wed, 24 December 2008 00:43
user_name is 42278 and password is fdg456


That is an invalid username in Oracle. There are ways around it, but since you are starting out, it's best not to know how to do unconventional things.
Re: login comand (merged) [message #378031 is a reply to message #377711] Sat, 27 December 2008 23:39 Go to previous messageGo to next message
CLS63AMGV8
Messages: 11
Registered: November 2008
Location: Oman
Junior Member
thanks all for passing and replying
so what about this comand
declare
x number;
begin
if :users11.username= 'hct ' and
:users11.pass_word= 'hct'
then
call_form(' C:\Documents and Settings\student\Desktop\PROJECT Group 2\UserPass.fmx');
else
x:=show_alert('alert7');
end if;
end;
Re: login comand (merged) [message #378037 is a reply to message #378031] Sun, 28 December 2008 01:02 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Instead of posting in bold, colored and big size, read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: Explicit Cursor
Next Topic: password
Goto Forum:
  


Current Time: Fri Feb 07 21:29:47 CST 2025