CODEWITHSUNDEEP
openoffice.org
Viikrant Dahiya
Viikrant Dahiya

Reputation: 1

open office database password protection

I have a question regarding password protection to a table I created when I developed my database using Open Office. I want to know how can I make a single table as password protected? eg, I have a database named Data I created a table named Data-table How can I provide a password protection on this table in open office?

Upvotes: 0

Views: 656

Answers (1)

Jim K
Jim K

Reputation: 13819

In any database, access permissions are granted to specific database users. So in the initial OpenOffice Base connection setup you need to choose a specific user. (If you do not choose a specific user, the default is the SA account which has rights to all tables.)

To grant access, you need to execute a GRANT statement for that user. Examples using mysql are given at http://dev.mysql.com/doc/refman/5.7/en/grant.html:

GRANT ALL ON db1.table1 TO 'jeffrey'@'localhost';

If you are using the default HSQLDB engine with both the client and database in a single file, then in order to connect as a specific user, I think you need to convert it to a more powerful client/server setup.

To do this, you can either unzip the .odb file and extract the HSQLDB files (see here), or copy the data into a mysql database or other database of your choice. Once the data is in a separate database, it should not be hard to do what you are asking.

Upvotes: 2

Related Questions