Ask Your Question
0

How to limit access to a form or query?

asked 2017-08-25 14:09:56 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

In Base, is there a way to limit access to a form(s) or query(s) to a specific user or users? For example, I want User A to be able to see /run Queries 1,2, and 3, but not to be able to see / access Form AA. Don't want anyone other than me to see / access the underlying Tables. thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-08-25 17:18:53 +0200

Ratslinger gravatar image

updated 2017-08-25 17:21:04 +0200

What you are asking for is not built into Base or the DB it comes with (HSQLDB embedded). There are many alternatives which require additional work on your part.

Base is just a front end to a database. It allows the connection to the DB. Having access to specific tables or queries can be controlled by user if the database your use runs in server mode. There are many to choose from - HSQLDB server, MySQL, PostgreSQL and more (see this link for more info - click here). You then will need to connect Base to the DB using a connector for that DB - see Chapter 2 Creating a Database in the LO documentation (click here).

You can also "Hide" the main form of Base - see this post and this post.

For specifically limiting form access by user, you would probably need to incorporate your own macro coding. This could possibly be tied into the DB user sign-on.

Also, if getting involved with macros, they can be secured. See this post.

As you can see there is no simple solution to your question but depending upon your needs there are methods available.

edit flag offensive delete link more

Comments

Thanks! I will study all of the info you provided.

WayneRhodes gravatar imageWayneRhodes ( 2017-08-25 18:53:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-08-25 14:09:56 +0200

Seen: 80 times

Last updated: Aug 25 '17