Posts

Postgres: Revoke create parition

 revoke create on schema cpnadmin from cpnadmin; In  PostgreSQL , there is  no specific privilege called  CREATE PARTITION  that you can directly  GRANT  or  REVOKE  on a table. Partition creation is  not a standalone privilege  — it is tied to  table ownership . Only: The  table owner  (or a role that is a member of the owning role) A  superuser can create partitions for a partitioned table. This means: If a role can create partitions, it’s because it  owns the table  (or is a member of the owner role). To  remove  that ability, you must  change the table’s ownership  or remove the role from the owner group — not by  REVOKE .
Post a Comment
Read more

db2 CCPA ecom grants

 [prd1ins1@db2prd601  ~] $ db2 " grant connect on database to user ccpa_db2_prd_user" DB20000I  The SQL command completed successfully. [prd1ins1@db2prd601  ~] $ db2 "grant role db2read to user ccpa_db2_prd_user" DB20000I  The SQL command completed successfully. [prd1ins1@db2prd601  ~] [tst2ins2@db2tst601  ~] $ db2 "grant connect on database to user ccpa_db2_tst_user" DB20000I  The SQL command completed successfully. [tst2ins2@db2tst601  ~] $ db2 " grant role db2read to user ccpa_db2_tst_user" DB20000I  The SQL command completed successfully. [tst2ins2@db2tst601  ~] $ Welcome@12345  ccpa_db2_tst_user /   SfYn##+[+m1  ccpa_db2_prd_user /  aIuyM~?ozp1
Post a Comment
Read more

Postgres: Reindex an index concurrently

  reindex index CONCURRENTLY <indexname> ;
Post a Comment
Read more

Postgres: Check index bloating

 SELECT current_database(), nspname AS schemaname, tblname, idxname, bs*(relpages)::bigint AS real_size,   bs*(relpages-est_pages)::bigint AS extra_size,   100 * (relpages-est_pages)::float / relpages AS extra_pct,   fillfactor,   CASE WHEN relpages > est_pages_ff     THEN bs*(relpages-est_pages_ff)     ELSE 0   END AS bloat_size,   100 * (relpages-est_pages_ff)::float / relpages AS bloat_pct,   is_na   -- , 100-(pst).avg_leaf_density AS pst_avg_bloat, est_pages, index_tuple_hdr_bm, maxalign, pagehdr, nulldatawidth, nulldatahdrwidth, reltuples, relpages -- (DEBUG INFO) FROM (   SELECT coalesce(1 +          ceil(reltuples/floor((bs-pageopqdata-pagehdr)/(4+nulldatahdrwidth)::float)), 0 -- ItemIdData size + computed avg size of a tuple (nulldatahdrwidth)       ) AS est_pages,       coalesce(1 +  ...
Post a Comment
Read more

Openssl - PKCS12

Image
 
Post a Comment
Read more

MySQL: DB connection with SSL and keystores

Image
  Create Client pkcs#12   openssl pkcs12 -export -in /etc/mysql/certs/client-cert.pem -inkey /etc/mysql/certs/client-key.pem -certfile /etc/mysql/certs/ca-cert.pem -out /tmp/client-keystore.p12 -name mysqlclient -passout pass:changeit   Create Trusstore PKCS keytool -import -trustcacerts -file /etc/mysql/certs/ca-cert.pem -alias mysqlserver -keystore /tmp/mysql-truststore.p12 -storetype PKCS12 -storepass changeit -noprompt   JDBC URL:   jdbc:mysql://mysql-pmmdevdb601.gcp.tmw.com:3306/pmmdvlp?useSSL=true&requireSSL=true&verifyServerCertificate=true&clientCertificateKeyStoreUrl=file:/tmp/client-keystore.p12&clientCertificateKeyStorePassword=changeit&clientCertificateKeyStoreType=PKCS12&trustCertificateKeyStoreUrl=file:/tmp/mysql-truststore.p12&trustCertificateKeyStorePassword=changeit&trustCertificateKeyStoreType=PKCS12   jdbc:mysql://mysql-pmmdevdb601.gcp.tmw.com:3306/pmmdvlp?useSSL=true&requireSSL=true&verifyServerCer...
Post a Comment
Read more

Unix: To check when last a password was changed

 [root@pshrps601 ~]# chage -l psoft Last password change                                    : May 24, 2010 Password expires                                        : never Password inactive                                       : never Account expires                                         : never Minimum number of days between password change          : -1 Maximum number of days between password change          : -1 Number of days of warning before password expires       : -1 [root@pshrps601 ~]#
Post a Comment
Read more