I need to give to user TARGETUSER the rights to select/insert/update to all tables of user SOURCEUSER (I can figure this all out from here) and the ability to run all their stored procedures. Basically, I wouldn't complain if I can give TARGETUSER the ability for all non-ddl activity with SOURCE_USER's objects. How do I do this? ...
The standard way that our applications pass information from oracle stored procedures to the oracle .net provider is via an out ref cursor parameter. In the past all of our stored procedures used to be in packages and had something like this: CREATE OR REPLACE PACKAGE test_package IS TYPE refcur IS REF CURSOR; PROCEDURE get_info ...
I have just walked out of a meeting room steaming after having to unsuccessfully argue the case for retaining our (development team's) Domain Admin / Oracle DBA access privileges. We support day to day production issues as well as a nationally critical process that happens three times a week. On top of this our DBA has no SQL experience ...
I seem to have problem getting linked servers working to query between database/servers running sql2000 32bit and 64bit sql2005. Is this a known bug? If so, is there a workaround, or fix? ...
Update: I tried to run this on a local instance of sql-server and sadly it worked!!! now I know that the code is right and there is some kind of DBA restriction I need to find (and ask the DBA to remove) Any ideas? using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.Data; na...
objective: to install oracle 10g xe on ubuntu. method followed :www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html problem: The installation went fine and at 1 point it asked me for a password for the system account and I gave it lets say 'securepassword' that. Now, I have 2 problems: I want to create a database. There is ...
As a DBA for MS SQL 2000 and 2005, I regularly see giant select queries JOINing 7-10 or even more tables. I find, though, that there is a certain point past which performance tends to suffer, and the query becomes very difficult to debug and/or improve. So is there a "rule of thumb" for when I should be considering other query methods, ...
Input: The customer claims that the application (.NET) when querying for some data returns data different from when the customer looks into the data table directly. I understand there could be various reasons and in completely different places. My purpose is not to solve it here, but rather to ask experienced DBAs and DB developers if:...
Hi, Does anyone knows any free alternative MySQL Enterprise Monitor? I need some tool, that allows me to monitor my 3 servers with replication without having to open ssh console, and use command line. Regards, Pedro ...
I have an opportunity to make a career move to dba from developer. I graduated college two years ago and enjoy development but I feel like I need to be researching new technologies if I'm going to keep up with the industry. I enjoy development but I also find it fun when trying to come up with complex sql statements. I'm thinking of swit...
Wondering what is the best or most popular database client tool. Similar to Microsoft's SQL management studio, but one that can work with various databases. Other tools I have found are: Toad for SQL Server Database fishing tool Apex SQL Studio Some of these tools can even compare and sync database schema's and some cases the data ...
In modern versions of Oracle, is there some "standard" (stored procedure, additional CREATE syntax, etc.) way to setting up a table with auto_increment/identity style column, or are we still stuck manually creating the table, creating the sequence, and creating the trigger. Update: I realize Oracle has no concept of an auto_increment. ...
One of my developers working on a trigger-based logging facility in SQL Server 2008 asked me if there was a command to retrieve the most recently executed SQL command within T-SQL. I thought there was a system stored procedure for just such a function, but it's possible I'm thinking of another product from a prior decade... online searc...
Does altering the JOB_QUEUE_PROCESSES to 0 on an Oracle DB block the Oracle jobs from being scheduled too? I found in http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/jobq.htm some information about it, principally, the following: The JOB_QUEUE_PROCESSES initialization parameter controls whether a coordinat...
Hi.I'm building a web site that's showcasing a large amount of products. I want the URL to be human-friendly and optimized for search engines, so I want the filtering of products to be reflected in the URL. For example, a possible URL path for filtering the products would be website.com/Type/Car/Country/Usa/Manufacturer/Ford/Year/2007 ...
I've now worked at a few tech companies ranging from 10 people to ~150 and I've never encountered a real DBA. How big does a company need to get before it merits getting a DBA? What are the criteria that need to be met? ...
Creation of objects like tables and indexes are fairly essential, even if the code has to be authorized or created by the dba. What other areas normally carried out by dbas should the accomplished developer be aware of? ...
I must say, I'm bored of phpmyadmin. We are in 2009 and have to work with this usefull tool and to wait everypage to reload after every action. Are any ajaxed alternatives outhere? Maybe phpmyadmin himself is going to be ajaxized? ...
Is it possible copy the physical Transaction log file for SQL 2005? Currently our databases are backed up every night with hourly Transaction logs taken during the day. Is it possible that after the hourly backup has been done that the physical log file can be copied to another server? what steps would need to be taken to get this to...
...and how should those permissions be granted. I work in a large IT dept with 70+ applications, some in SQL server and most in oracle. Each system has a prod, QA and Dev instance. We (I'm a developer) have readonly access to prod/qa, which I'm fine with. In SQL server development instances devs are given db_owner, which works totall...