Re: Some ideas in SE-PostgreSQL enhancement (Re: The status of SE-PostgreSQL)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





Joshua Brindle wrote:
Andy Warner wrote:
  
I see now. When the db object classes were proposed we hoped they would be
general enough to cover other dbms's, it looks like we weren't far off. 
      
Other than omitting the catalog and schema object classes, which are SQL 
standard objects (though sparsely used and poorly defined), I would agree.
    
I have
some comments for permission sets found in the document mentioned above, for
example:

CREATE TABLE: db_database {access}; dir {search} on catalog; dir {search
add_name} on schema; db_table {create} on table

you require dir search, add_name. What is the source context in this case? Is
Trusted RUBIX doing avc_has_perm calls with dir as the object class on behalf of
the connected client or is the server masquerading as the client and those
checks are done by SELinux? I don't think it is a good idea to muddle the object
class ownership concept by doing checks for classes which are owned by another
object manager (except in the case that you are proxying access for that object
manager, such as the case for samba).
  
      
Trusted RUBIX does all security decision checks using avc_has_perm on 
behalf of the connected client. We use the SELinux mechanism for access 
control decisions and never for enforcement (I am speaking of only DBMS 
objects). All DBMS object contexts are maintained internally in the 
database. RUBIX enforces all decisions. Note that the schema is not an 
OS directory, it is purely an internal DBMS object. I only used the dir 
object class because there was no support for the DBMS schema or catalog 
objects. I believe there will be support for this in the future, at 
which time we would replace the use of the dir class with the db_schema 
or db_catalog.
    

I'd have hoped our community was seen as open enough to approach about the added
object classes and perms.
  

Please don't take my lack of asking for new object classes as anything other than ignorance as to how things "work" in the open source community. All of our previous work has been on proprietary MLS systems. The idea of asking an OS vendor or community to add features for my needs was foreign to me. Plus, my time constraints on the project may not have allowed it. I have found this community to be very open and helpful and always planned to give some input as to the need for these object classes after my project was finished (which is now).
  
So, internally, the access checks on the database and catalog are 
performed when those objects are opened. During the actual create table 
operation we have two calls to avc_has_perm, the first checks the 
client's context, schema's context for dir {search add_name} and the 
second checks the client's context, table's context for db_table {create}

Could you elaborate on what you mean by "I don't think it is a good idea 
to muddle the object
class ownership concept by doing checks for classes which are owned by 
another
object manager" ? In what way is an object class *owned* by an object 
manager? I'm a newbie in this area and would appreciate some 
constructive criticism.

    

So, overloading object classes leads to confusion and other issues. For example,
if an actual directory got labeled what the internal catalog was labeled then
the client would have access to that, even if that wasn't the intention. There
also may be conflicting type_transition rules because you end up wanting one
object label transition to be different from another when used on the different
kinds of objects.
  
Yep, I can see that as an issue. Practically speaking, I would think the new object classes will be added before any such real issue arose. But, isn't there a similar issue, say, between a system with a sepostres policy and a Trusted RUBIX installation on the same platform? I have already bumped up against some of the type_transition rules for sepostgres.
The flask architecture was originally implemented in a microkernel where object
managers were services that enforced access per the security servers decision.
In that architecture an object manager would be responsible for the object class
it was enforcing access on. Stephen can correct me here if I'm wrong but I
object to object class overloading based on these issues.
  

In your terminology, because rubix is enforcing the policy, would it be considered an object manager? And, if so, wouldn't seposgres also be considered one? where they both enforce access to the same set of object classes?
  
Were the db object classes incomplete for you so you needed to use filesystem
object classes? I'm trying to get a feeling for what the motivation was behind
these checks.
  
      
Yes, if the db object classes supported schema and catalog I would not 
use the dir. I'm not sure what to say for motivation, other than I felt 
it important and useful to have security checks on our catalog and 
schemata. And, since these objects function very closely to an OS 
directory, and there was no support for the catalog and schema objects 
in the selinux policy, and I decided not to modify the targeted/mls 
policies as part of our release, I chose to use the dir object class. 
Actually, I think I got the idea from an old post on this newsgroup. The 
options presented in that post were to either modify the policy's object 
class and permissions or overload a pre-existing object class. I chose 
the latter. It was the lesser of two evils. I didn't  want to have to 
keep up with updates to the targeted/mls policies.
    

See above, you brought up another issue here where permissions being overloaded
may not have the same read/write mappings and therefore may be difficult to work
around with respect to the MLS policy. Approaching the community to work on a
common set of object classes/perms and getting them merged in to upstream
refpolicy is definitely the right answer.
  
I agree completely.
  
Is Trusted RUBIX with these SELinux checks actually released, are the access
checks set in stone? I'd like to see as much consistency between dbms object
models as possible so that policy won't be dramatically different between them.
  
      
Yes, Trusted RUBIX with these security checks is released. But no, they 
are not set in stone. The minute a new policy is released supporting the 
db_schema and db_catalog object classes will be the time I change our 
product to use them, and stop using the dir object class.

    

Good. Hopefully we can get this worked out between you guys and have a
consistent (and documented) set of permissions that make it easy to write policy
that works on both systems (as much as possible)
  
I think that is well on its way. One question out of curiosity. Would you anticipate that I should or would use the seposgres TE rules that already exist in the targeted/mls policy? I ask that from your comment about writing policy that that works on both systems. With current state of things this seems very difficult, though, I think a higher level interface set, like the one we created for the object set, could be made that, for the most part, worked for both systems.
  
To my knowledge there are only two DBMS's that integrate SELinux into 
its product, SEPostgresql and Trusted RUBIX. I'm not so sure I would say 
our DBMS object models are dramatically different.  SEPostgresql does 
not have a catalog object and chose not to have selinux control over 
their schema object. From looking at KaiGai's work and posts I think in 
the future they will support the schema object, in much the same way I 
tried to in our current release.
    

They chose not to for now, the initial set of permissions used by SEPostgres
looks like it is going to be minimal, unfortunately, but should evolve into
something more comprehensive.

I may be missing it but do you support 'domain-like' type_transitions for stored
procedures? This was one of the more interesting features in the initial
sepostgres patches IMHO because it allowed for trusted stored procedures that
can read tables the client couldn't necessarily read, and could do operations on
them before handing over the data (eg., fuzzing of coordinates)
  
We do not implement stored procedures at all, though this is a near future possibility. As I said before, our background is MLS and often in the EAL-5+ type (old B3). The group-think was always that stored procedures were too insecure for such assurance levels. But, I have been pushing the possibility in a EAL-4 type mode, for exactly the reasons you mentioned above. With the selinux domain transition concept a stored procedure becomes very interesting.
--
This message was distributed to subscribers of the selinux mailing list.
If you no longer wish to subscribe, send mail to majordomo@xxxxxxxxxxxxx with
the words "unsubscribe selinux" without quotes as the message.

  

[Index of Archives]     [Selinux Refpolicy]     [Linux SGX]     [Fedora Users]     [Fedora Desktop]     [Yosemite Photos]     [Yosemite Camping]     [Yosemite Campsites]     [KDE Users]     [Gnome Users]

  Powered by Linux