OraFAQ Forum: Security » how to set umask value to 022 from sql * plus

Home » RDBMS Server » Security » how to set umask value to 022 from sql * plus (oracle enterprise 11g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to set umask value to 022 from sql * plus [message #624343]

Mon, 22 September 2014 05:00

cleuser
Messages: 2
Registered: September 2014

Junior Member

i use window 7, and i install oracle enterprise 11g on it. i google how to set umask parameter but all i get is the using of the command umask 022 which is used in linux, but i want to set it from sql * plus, would anyone please help me that what the command is?

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624348 is a reply to message #624343]

Mon, 22 September 2014 05:27

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ There is no umask on Windows
2/ Why do you want to do it from SQL*Plus?

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624353 is a reply to message #624348]

Mon, 22 September 2014 05:45

cleuser
Messages: 2
Registered: September 2014

Junior Member

i am just learning how to secure oracle database, one of the items was checking umask value and setting the value to 022.
as i told because i'm using windows and i installed oracle on it, i think that the solution is using sql * plus.is there any solution?
what's the reason "There is no umask on Windows"?
Thanks.

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624358 is a reply to message #624353]

Mon, 22 September 2014 06:15

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Plus is not to make action at OS level, it is not its purpose, its purpose is to execute SQL and PL/SQL.
Now you can do something but surely not to get something that does not exist. "umask" does not exist on Windows so you cannot execute or get "umask".

Quote:

what's the reason "There is no umask on Windows"?

Because it is not Unix.
What's the reason the is no Internet Explorer on Unix?

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624402 is a reply to message #624358]

Mon, 22 September 2014 10:11

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

SQL*Plus is not to make action at OS level

SQL> host cd
E:\oracle\scripts

SQL> host mkdir temp

SQL> host dir temp
 Volume in drive E is Programs
 Volume Serial Number is E6F5-AB5F

 Directory of E:\oracle\scripts\temp

22/09/2014  15:03    <DIR>          .
22/09/2014  15:03    <DIR>          ..
               0 File(s)              0 bytes
               2 Dir(s)  15,883,980,800 bytes free

SQL>

Quote:

What's the reason the is no Internet Explorer on Unix?

No. Internet Explorer is an application. The reason there is no umask on Windows is because they use different file-systems.

HTH
-g

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624408 is a reply to message #624402]

Mon, 22 September 2014 10:28

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

No. Internet Explorer is an application. The reason there is no umask on Windows is because they use different file-systems.

Yes, IE is a program, umask too.

OK, I could say.
What's the reason there is no services (in Windows meaning otherwise you will say there are services as there are in post office) on Unix? Because it is not Windows.

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624409 is a reply to message #624408]

Mon, 22 September 2014 10:33

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Of course there are services on Unix! Try:

$ cat /etc/services

Or if you need help:

$ man services

You're right in that they are implemented differently yet wrong to say Unix has none.
Quote:

(in Windows meaning otherwise you will say there are services as there are in post office)

I have been accused of being a pedant by Michel! Have I reached enlightenment? Laughing

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624412 is a reply to message #624343]

Mon, 22 September 2014 10:37

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

I think the closest you'll find to umask on Windows is Access Control Lists. You configure them with cacls.exe (or the newer utility, icacls.exe). Good luck.

Report message to a moderator

Re: how to set umask value to 022 from sql * plus [message #624414 is a reply to message #624409]

Mon, 22 September 2014 10:38

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Of course there are services on Unix! Try:

Stupid! These are not services in Windows meaning as I specified.

Quote:

I have been accused of being a pedant

What is sure is most of your answers (choose one): wrong, out of the scope of the topic, partial/not complete, in short not accurate. Sad

Report message to a moderator

Previous Topic:	Locking the system user id in oracle
Next Topic:	dbms_fga.add_policy issue?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 24 01:42:07 CST 2026