Home » RDBMS Server » Security » how to set umask value to 022 from sql * plus (oracle enterprise 11g )
how to set umask value to 022 from sql * plus [message #624343] Mon, 22 September 2014 05:00 Go to next message
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?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
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?

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 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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
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 Go to previous messageGo to next message
John Watson
Messages: 7936
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.
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 Go to previous message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
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

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


Current Time: Thu Jun 20 06:41:33 CDT 2019