Re: Can I hide the structure of a database?

Wolf P'ter wrote: > > I would like to hide the structure of a database from nosy individuals? > > I know it's possible creating "secure" stored procedures (i.e. one that > nobody knows what it does) is to remove the uncompiled version from the > database. > > But what about the table names, columns, foreign keys and others? You can do it with schemas and views. Revoke whatever privileges you want on the logical schema, create views of the parts you want folk to see and grant appropriate privileges. I haven't tried this and there's a niggling doubt in my mind about the SYS tables still being visible. Anyone know more than I do (stupid question - course you do)? Before going to this bother, why do you need to hide it? If the users can't change the structure it won't do any harm for them to see it, will it? If you have individuals who see all information as theirs by right and waste time trying to discover it maybe you have a staff problem? Sometimes the technical fix is not the right one. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/