Unix Technical Forum

Re: Question about permissions used on onconfig and sqlhosts files

This is a discussion on Re: Question about permissions used on onconfig and sqlhosts files within the Informix forums, part of the Database Server Software category; --> Andrew Hamm wrote: > I've long whinged bitterly at people who install Informix into the same > directory that ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 07:14 PM
Mark D. Stock
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files


Andrew Hamm wrote:

> I've long whinged bitterly at people who install Informix into the same
> directory that is the informix account's home. Unfortunately nothing hase
> been done traditionally to prevent this. My complaint about people who do
> that is, they do work using the informix account and leave all sorts of crap
> lying around. Is there any way to enforce that $INFORMIXDIR != ~informix ???
> or make $INFORMIXDIR completely unwritable?


You can set the home directory of the informix user to whatever you want.
That is entirely under the control of UNIX. I've been to many sites where
$INFORMIXDIR and ~informix are different. Personally I find that mildly
irritating, as when I login as informix I expect to be administering
informix S/W. The simplest form of security, IMHO, is to treat the informix
password just as you do the root password. Of course, if you've seen how
some people treat the root password, then you will know that it's not much
help. ;-)

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 07:14 PM
Andrew Hamm
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

Mark D. Stock wrote:
>
> You can set the home directory of the informix user to whatever you
> want. That is entirely under the control of UNIX. I've been to many
> sites where $INFORMIXDIR and ~informix are different. Personally I
> find that mildly irritating, as when I login as informix I expect to
> be administering informix S/W. The simplest form of security, IMHO,
> is to treat the informix password just as you do the root password.
> Of course, if you've seen how some people treat the root password,
> then you will know that it's not much help. ;-)


The installation directory is just a

cd $INFORMIXDIR

away. The problem lies with people (not necessarily you, just at some places
I see) leaving crap around and also risking damage with random clumsy
activity.

Precisely because Informix needs to be a working account with a specialist
role, is deserves it's own home directory so that scripts, working files and
assorted junk can be safely developed, classified and stored, without
putting any risk what-so-ever upon the actual installed product.

Remember, Shit Happens. Hands up all administrators who HAVEN'T yet done
some accidental damage while working as Informix, root, or other critical
account?

*scans the world* See - I rest my case. No hands raised.



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-19-2008, 07:14 PM
Obnoxio The Clown
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

Andrew Hamm wrote:

> Remember, Shit Happens. Hands up all administrators who HAVEN'T yet done
> some accidental damage while working as Informix, root, or other critical
> account?
>
> *scans the world* See - I rest my case. No hands raised.


You didn't allow for the UK time difference.

--
Ciao,
The Obnoxious One

"Ogni uomo mi guarda come se fossi una testa di cazzo"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-19-2008, 07:14 PM
Paul Watson
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

[cutting]

> Remember, Shit Happens. Hands up all administrators who HAVEN'T yet done
> some accidental damage while working as Informix, root, or other critical
> account?


I'm a professional (allegedly), all my f*%k ups are carefully planned
and well documented:-)) I know I'm newfs'ing the disk and I know the
disk is a dbspace and I just forgot - OK it happens.

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-19-2008, 07:15 PM
John Carlson
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

On Wed, 29 Oct 2003 08:24:59 +0000, Paul Watson <paul@oninit.com>
wrote:

>[cutting]
>
>> Remember, Shit Happens. Hands up all administrators who HAVEN'T yet done
>> some accidental damage while working as Informix, root, or other critical
>> account?

>
>I'm a professional (allegedly), all my f*%k ups are carefully planned
>and well documented:-)) I know I'm newfs'ing the disk and I know the
>disk is a dbspace and I just forgot - OK it happens.


Is that while wearing your DBA hat or your SysAdmin hat???? 8-)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-19-2008, 07:15 PM
Paul Watson
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

John Carlson wrote:
>
> On Wed, 29 Oct 2003 08:24:59 +0000, Paul Watson <paul@oninit.com>
> wrote:
>
> >[cutting]
> >
> >> Remember, Shit Happens. Hands up all administrators who HAVEN'T yet done
> >> some accidental damage while working as Informix, root, or other critical
> >> account?

> >
> >I'm a professional (allegedly), all my f*%k ups are carefully planned
> >and well documented:-)) I know I'm newfs'ing the disk and I know the
> >disk is a dbspace and I just forgot - OK it happens.

>
> Is that while wearing your DBA hat or your SysAdmin hat???? 8-)


I'm not jobist - I f*%k up wearing either hat:-))

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-19-2008, 07:15 PM
Obnoxio The Clown
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

Paul Watson wrote:

> John Carlson wrote:
>>
>> On Wed, 29 Oct 2003 08:24:59 +0000, Paul Watson <paul@oninit.com>
>> wrote:
>>
>> >[cutting]
>> >
>> >> Remember, Shit Happens. Hands up all administrators who HAVEN'T yet
>> >> done some accidental damage while working as Informix, root, or other
>> >> critical account?
>> >
>> >I'm a professional (allegedly), all my f*%k ups are carefully planned
>> >and well documented:-)) I know I'm newfs'ing the disk and I know the
>> >disk is a dbspace and I just forgot - OK it happens.

>>
>> Is that while wearing your DBA hat or your SysAdmin hat???? 8-)

>
> I'm not jobist - I f*%k up wearing either hat:-))


And sometimes he doesn't even leeeeeave his hat on... )

Oh, what a charming mental image. Sometimes I even make myself ill.

--
Ciao,
The Obnoxious One

"Ogni uomo mi guarda come se fossi una testa di cazzo"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-19-2008, 07:16 PM
Andrew Hamm
 
Posts: n/a
Default Re: Question about permissions used on onconfig and sqlhosts files

Obnoxio The Clown wrote:
> Andrew Hamm wrote:
>
>> Remember, Shit Happens. Hands up all administrators who HAVEN'T yet
>> done some accidental damage while working as Informix, root, or
>> other critical account?
>>
>> *scans the world* See - I rest my case. No hands raised.

>
> You didn't allow for the UK time difference.


I didn't think I needed to add such an obvious exception clause such as
"Hands up all administrators that are not perfect ...."


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:56 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com