Get updates from Alter-database via email, on your phone or read them on follow.it on your own custom news page.
You can filter the news from Alter-database that get delivered to you using tags or topics or you can opt for all of them. Unsubscription is also very simple.
See the latest news from Alter-database below.
Site title: Database Technology
Is this your feed? Claim it!
-- List all users present in mysql
mysql> select user,host,account_locked,password_expired from mysql.user;
Create user in mysql:
mysql> CREATE USER 'test_user'@'%' IDENTIFIED BY 'test_user';
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL ON *.* TO 'user'@'localhost';
Reading MSSQL DB data from Oracle 19c database using DB link & ODBC Drivers :
****************************************************************************
List of steps:
**************
1. Root - Install Microsoft SQL server ODBC drivers.
sudo ACCEPT_EULA=Y yum install -y msodbcsql17
2. Root - Create ODBC entry i...
Linked Server in MS SQL Server
-----------------------------------
Source : MS SQL 2019 EE on Windows 22
Target : Oracle 19c R2 EE on Linux 8 - IP - 192.168.56.74 Port- 1583 ServiceName- ORA_DB_19c
Pre-Req:
-----------
a. You must have Oracle client installed on MSSQL server.
b. Wor...
1.select 'grant usage on schema ' ||nspname||' to <new_group_name>;' from pg_catalog.pg_namespace
where nspname not in ('public','pg_catalog','catalog_history','information_schema','dbainfo') and nspname not like 'pg_%'; ---1
2.select 'grant select,insert,update,delete on all tables in schema ' ||nspname||' to <new_...
SQL script to change the ownership of schema, table ,procedure in AWS Redshift Database
1.change the ownership of schema
select 'alter schema ' ||nspname||' owner to "<new_schema_name>";' from pg_catalog.pg_namespace
where nspname not in ('public','pg_catalog','catalog_history','information_schema','dbainfo'...