Using SYSTEM user I create a new user. After that I try to give this user access to specific columns only in 1 table, but get the error that this table does not exist. Meaning that SYSTEM user does not have access to this table. Unfortunately, the user that has access to the normal production tables cannot manage user privileges
Tag: database-administration
Multi-tenant database : create .BAK file for single tenat
In my application I use multi tenant design in my SQL Server database. My question is: what if one of my customer comes and say, I want my own data as a backup file, how can I create backup file for just that tenant? Is there is any way to do that? Do I need any 3rd party tool? Can
Strange variables MySQL [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 11 months ago. Improve this question Can someone tell me what “skip_name_resolve” and “skip_grant_tables” MySQL variables do
SQL -Pivoting a column from a table which have Unique records
I am trying to pivot a table to Row which have duplicate records on all columns but, a unique ID Named ([log_ID]) at the last columns . I wont log_ID field pivoted and given dynamic name as log_ID_1 ,log_ID_2 …etc FYI – THE log_ID’s is not static they change at every execution’s they could be less or more . My
Query to find the tables size occupied in GB in Oracle SQL for various SCHEMAS
I am trying to find the space occupied by list of tables in Oracle DB (for various SCHEMAS ) ,currently i am using this query QUERY 1 – DBA_SEGMENTS QUERY 2 – DBA_OBJECTS when i compare the LIST OF TABLES counts it’s not matching , what could be the reason ? can you please suggest is this correct or is
Replace Database WIth Copy Of Other Database
As part of our testing process, I’m trying to automate the following: Drop DatabaseB. Create a backup of DatabaseA Recreate DatabaseB from the backup of DatabaseA I had hoped something like this would work RESTORE DATABASE DatabaseB FROM DISK = ‘c:tempDatabaseA.bak’ WITH REPLACE, but that turns out to want to overwrite the existing ldf and mdf files for DatabaseA. It
Enabling CDC in SQL Server 2005 won’t work?
I am trying to use AWS replicate following this tutorial – https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.CDC.Publication . Using this code on a 2005 Microsoft SQL table Results in Could not find stored procedure ‘msdb.dbo.rds_cdc_enable_db’. This is the driver currently MS SQL Server / SQL Server (Old driver, jTDS) Any idea on how to overcome this issue? Answer CDC is not available in SQLServer 2005.
ORA-01219: database not open: queries allowed on fixed tables/views only
I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- I looked for sgadef.dbf file and it was missing in home directory.. Can someone help me to make it working. Answer First of all check the status of the instance you work with (this may need
Cannot create a table due to naming conflict
I am trying to create a table in my database and it gives me the following error. Then I thought that the table must exist so I ran the following query: But could not find anything. Then I tried: Any idea how to sort this? i am tying to rename the type by and getting the error. Answer Postgres creates