Question : DBMS allows the admin to grant table access to a user using something like: GRANT ALL ON mydb.mytbl1, […]
Tag: access-control
Create Temporary Access to production support
Question : We’re thinking of creating a web site where a manager can provide temporary access to a person for […]
Use large set of data in multiple databases
Question : I have been thinking about this a lot but somehow can’t figure out how to deal with it […]
Adding group rights in db2 for a stored procedure
Question : I have a list of user accounts on AIX server, where the db2 database resides in. The user […]
How to set user-level security in 2007+ MS Access?
Question : I’ve read this MS info which should cover my problem. There are quite clear steps: Open the .mdb […]
How do I prevent my clients viewing my database definition when it is installed on their server?
Question : I want to give my database to the client to install on their server. However, I want to […]
Why do databases in mongodb have roles?
Question : I have read about mongodb role based access control and I have understood it to a large extent. […]
Revoking execute access on builtin functions on SQL Server
Question : I am trying to lock down a SQL Server database server and I want to revoke execute access […]
Why is database ownership by groups not allowed? Which user should own a database?
Question : Per microsoft “ALTER AUTHORIZATION for databases for SQL Server”: Requirements for the new owner: The new owner principal […]
Database logon trigger
Question : To block a particular user and IP combination on an Oracle Database , I created the following trigger, […]