On 10 Nov 2006 04:09:30 -0800, nalini wrote:
> Hi All:
>
> My company has Linux Server and Sybase database installed on it.I need
> to give access rights (for sybase) for only few members and restrict
> for the others.

Who has access now and by what mechanisms?

> one clue is by using IP address.
> But i need the command and which configuration file i need to change

Well, you also need an understanding of the situation. So, how are they
accessing the box now? Are you trying to restrict access to the datbase
or logins? Is this an internal system or on the internet? What flavor
of Linux? "It depends" is the best answer we could give at this point,
please give us some data to work with.

Begin <1163160570.349392.52040@b28g2000cwb.googlegroups.c om>
On 2006-11-10, nalini wrote:
> My company has Linux Server and Sybase database installed on it.I need
> to give access rights (for sybase) for only few members and restrict
> for the others.

Unix permissions aren't that difficult to understand, but they're only
part of the story. The database will have its own access permissions.
You will probably need fine grained access control, and for that you
need a good understanding of the issues and interplay between them.

If you have no idea how to do this, the quickest way is to hire someone
to discuss the access requirements in detail with you, then implement
them. Explaining over the 'net is cumbersome as it would come down
to giving you a two day course in the matter. That is theoretically
possible, but very few people are prepared to go that far.


--
j p d (at) d s b (dot) t u d e l f t (dot) n l .
This message was originally posted on Usenet in plain text.
Any other representation, additions, or changes do not have my
consent and may be a violation of international copyright law.

Data:

There is a development team and a test team.Each has a different setup
.. Of late i have seen some dev guys( i am from test ) using our
database. I am test lead and have the sys admin rights also.I want to
prevent the dev guys from using our database. e are using Turbo Linux
10 and sybase 12.5. I tried changing the /etc/host.deny file but
wasnot sucessful.


Dave Hinz wrote:
> On 10 Nov 2006 04:09:30 -0800, nalini wrote:
> > Hi All:
> >
> > My company has Linux Server and Sybase database installed on it.I need
> > to give access rights (for sybase) for only few members and restrict
> > for the others.
>
> Who has access now and by what mechanisms?
>
> > one clue is by using IP address.
> > But i need the command and which configuration file i need to change
>
> Well, you also need an understanding of the situation. So, how are they
> accessing the box now? Are you trying to restrict access to the datbase
> or logins? Is this an internal system or on the internet? What flavor
> of Linux? "It depends" is the best answer we could give at this point,
> please give us some data to work with.

On 12 Nov 2006 21:25:54 -0800, nalini wrote:
> Data:
>
> There is a development team and a test team.Each has a different setup
> . Of late i have seen some dev guys( i am from test ) using our
> database.

First, please don't top-post, it makes following the flow of a technical
discussion very difficult. Your answers don't have any context when the
questions are way down on the bottom, unreferenced.

> I am test lead and have the sys admin rights also.I want to
> prevent the dev guys from using our database. e are using Turbo Linux
> 10 and sybase 12.5. I tried changing the /etc/host.deny file but
> wasnot sucessful.

I'll ask again - how are they accessing the system? Are they logging
in?

The real question is - have you addressed this situation from a "Hey
guys, stop doing that" perspective? If that's not working, there are
other problems not just the access methods itself. If they're logging
in, take away their logins. But I'm still not sure how they're "using
your database" at this point - meatware you also have to fix.