Proposed changes to Solaris_FileAttributes table

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Proposed changes to Solaris_FileAttributes table

Matthew N. Wojcik
I'd like to propose a couple of minor changes to the
Solaris_FileAttributes table.  If accepted, this would move the
Solaris schema to version 2.  Here's a summary of my proposals:

The "Owner" and "Group" columns will be renamed "UID" and "GID" first
because group is a reserved word in SQL (oops) and second to better
reflect the expected values: numeric user and group ids of the file's
owner and group, as reported by lstat().

The "Modified" column will be replaced with three time-related fields:
"Atime" "Ctime" and "Mtime" which will hold the file's access, status
change, and data modification times as an integer number of seconds
since 1970-01-01:00:00:00 UTC (midnight, 1 January 1970).  Again,
refer to the man page for lstat()

This date change is related to discussion the Board has had regarding
file dates (originally on the Windows platforms), where there were
acknowledged problems dealing with dates in more human-readable
formats.  The consensus seems to be that epoch dates are the most
useful, even if they may lead to slightly less-readable queries.  I
wanted to change the column name of the old "Modified" field to make
it clearer what date format was expected, and it seemed sensible to
add in the other file timestamps as they may prove useful in the
future as well.

Here's the full table with the proposed changes:

Solaris_FileAttributes: File metadata
----------------------
FilePath         -- Path to file.
FileType         -- Directory, named pipe, standard file, etc.
UID              -- File owner UID ** COLUMN NAME CHANGED FOR VERSION 2
GID              -- File group GID ** COLUMN NAME CHANGED FOR VERSION 2
Atime            -- Time of last file access, in seconds since
                 -- 1970-01-01:00:00:00 UTC ** NEW IN VERSION 2
Ctime            -- Time of last file status change, in seconds since
                 -- 1970-01-01:00:00:00 UTC ** NEW IN VERSION 2
Mtime            -- Time of last file data modification, in seconds since
                 -- 1970-01-01:00:00:00 UTC ** NEW IN VERSION 2
MD5              -- MD5 checksum
-- The following are the individual permission bits
SUID
SGID
STICKY
UREAD
UWRITE
UEXEC
GREAD
GWRITE
GEXEC
OREAD
OWRITE
OEXEC


Let me know what you think.

--Woj                  Matthew N. Wojcik                  [hidden email]
OVAL Moderator                                   http://oval.mitre.org/


Reply | Threaded
Open this post in threaded view
|

Re: Proposed changes to Solaris_FileAttributes table

Javier Fernández-Sanguino-2
Matthew N. Wojcik wrote:
> I'd like to propose a couple of minor changes to the
> Solaris_FileAttributes table.  If accepted, this would move the
> Solaris schema to version 2.  Here's a summary of my proposals:

(..)

I think those proposals are quite appropiate and might come handy at
some time. In my opinion these same changes should be made to both the
RedHat and Debian schema.

Regards

Javi


Reply | Threaded
Open this post in threaded view
|

Re: Proposed changes to Solaris_FileAttributes table

Jay Beale
In the wise words of Javier Fernandez-Sanguino:

> Matthew N. Wojcik wrote:
> >I'd like to propose a couple of minor changes to the
> >Solaris_FileAttributes table.  If accepted, this would move the
> >Solaris schema to version 2.  Here's a summary of my proposals:
>
> (..)
>
> I think those proposals are quite appropiate and might come handy at
> some time. In my opinion these same changes should be made to both the
> RedHat and Debian schema.


Definitely.

 - Jay