Is there any database system that allows to have different schemas for different users but the same content for all users?

Question

In my fantasies, it looks something like this:

User 1:

SHOW TABLES;
+-----------------------+
| Tables_in_my_database |
+-----------------------+
| table_1               |
| table_2               |
+-----------------------+

SELECT * FROM table_1;
+----+---------+---------------------+
| id | name    | created_at          |
+----+---------+---------------------+
| 1  | Erik    | 2014-09-09 18:31:34 |
| 2  | Richard | 2014-09-09 18:31:34 |
+----+---------+---------------------+

User 2:

SHOW TABLES;
+-----------------------+
| Tables_in_my_database |
+-----------------------+
| table_1               |
| table_2               |
| table_3               |
+-----------------------+

SELECT * FROM table_1;
+----+---------+---------------------+---------------------+
| id | name    | created_at          | email               |
+----+---------+---------------------+---------------------+
| 1  | Erik    | 2014-09-09 18:31:34 | [email protected]    |
| 2  | Richard | 2014-09-09 18:31:34 | [email protected] |
+----+---------+---------------------+---------------------+

Can we something like this be build in any database system?

Answer 1

Do you define "different content" as row filtering via security settings? That is pretty standard - and pretty unusual (as in: standard for high security, not all databases support this thinking)... SQL Server for example is just adding this with version 2016 due this year. In most cases... people do not bother as the filtering of what data is visible is done on the application layer (possibly in a server obviously).