News for hackers. Stuff that matters.

A comment on Instead of deleting account, NYT appends ‘1000’ to username and email address. Parent comment

Re:Instead of deleting account, NYT appends ‘1000’ to userna... by perl4ever on Tuesday April 28, 2020 @01:53PM (#23009774)
Eh, the situation that I've been in, if I recall correctly, is that one has read/write access to all data for reporting, but not the ability to create views (or stored procedures etc) to share.

Where I am now, (as far as Oracle goes) you can't even create your own tables under your own schema. A view requires a meeting with a DBA and their manager and really special, compelling arguments.

[ Parent | on HN ]
Re:Instead of deleting account, NYT appends ‘1000’ to userna... by lilyball on Tuesday April 28, 2020 @05:39PM (#23012437)
Can you just have a general policy where every table that has an is_deleted flag also automatically gets a view, and clients must use the view unless they have a particular need to access deleted data?
[ Parent | on HN ]