Hi everyone, in general, I’ve been asked by my manager to find out about running a mysql db on a cloud (like this one) — has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work [...]
Hi, My team and I are stuck. A 3rd party needs access to certain information on our Lotus Notes database about clients status and we are unsure on how to go about this without jeapodising security and firewalls. We’ve thought of a web based application for the 3rd party however how will we send them updated limited [...]
A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She’s now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later [...]
Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me……….
implementing roe level srcurity
Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert [...]
I have database in which docmens are created by various users. All users can see each other’s documents. I need the user’s to be able to ONLY see their documents they created. They are creating documents fro a form. When local copies are created, they get only their documents. How do I set up the [...]
I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do? [...]
Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.
I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?
How can i remove all instances of the following from my database? <script src=http://www.jic2.ru/script.js></script> thanks Bosco
What are the database security requirements in a Linux environment?
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights [...]
I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication server. There is no failover clustering or [...]
Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with [...]
Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question: Can we add another server and install [...]





