Stop People From Changing Tables with This One Trick

I received today's posts from Brent Ozar, I feel it is very interesting, LOL:


Brent Ozar says:
Stop People From Changing Tables with This One Trick

Brace yourselves. Our Black Friday sale is coming.
Developers hate his bad idea jeans:
CREATE VIEW dbo.StopThemDead WITH SCHEMABINDING
AS
SELECT COUNT(*) FROM dbo.Table1
UNION ALL
SELECT COUNT(*) FROM dbo.Table2
UNION ALL....
Presto, the schemabinding option means no one can change the underlying tables. (At least, until they figure out about your view.)
Obligatory disclaimer: seriously, this is a really bad idea. But it’s hilarious.

Comments

Post a Comment

Popular posts from this blog

Sysaux tablespace is too big

Image
 today I received my report alert regarding one of Oracle database tablespace SYSAUX is over 80% (I created automated job using SSIS package to check tablespace usage daily) following steps to resolve it:  /*  2021.07.08  Documentation steps for troubleshooting Sysaux tablespace is huge --85% full  */   ---1. see what uses the most select occupant_name,occupant_desc, space_usage_kbytes/1024 MB from v$sysaux_occupants where space_usage_kbytes > 0 order by space_usage_kbytes desc; ---find it is SM/Advisor Server Manageability - Advisor Framework 25GB --now look for top 10 big objects   select * from (                select bytes/1024/1024 MB, blocks, s.SEGMENT_NAME, s.partition_name, s.segment_type, s.tablespace_name                  from dba_segments s                 where owner='SYS'              order by bytes desc ) where rownum <=10 ; ---find it is WRI$_ADV_OBJECTS having 13GB and 1.7 million blocks --now check how many objects in dba_advisor_objects  select task_name
Read more

patching Oracle Database 12.2.0.1 Release Update & Release Update Revision January 2021 Critical Issues (Doc ID 2725763.1)

Image
 1 Determine current patch level D:\oracle\product\12.2.0\dbhome_1\OPatch>opatch lsinventory -patch -detail Oracle Interim Patch Installer version 12.2.0.1.6 Copyright (c) 2021, Oracle Corporation.  All rights reserved. Oracle Home       : D:\oracle\product\12.2.0\dbhome_1 Central Inventory : C:\Program Files\Oracle\Inventory    from           : OPatch version    : 12.2.0.1.6 OUI version       : 12.2.0.1.4 Log file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_12-46-58PM_1.log Lsinventory Output file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\lsinv\lsinventory2021-07-09_12-46-58PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: xxxx ARU platform id: 233 ARU platform description:: Microsoft Windows (64-bit AMD) There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPa
Read more
 Recently, moved most of my scripts to github, most for private repo for now, starting to extract general scripts and posted in    General DBA tips (zhoutransform.github.io)  https://zhoutransform.github.io/GeneralDBA/ 
Read more