starred/cloudbeaver

Fork 0

mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-26 22:26:01 +03:00

[GH-ISSUE #820] SQL Server, visibility of system objects #203

New issue

Closed

opened 2026-03-07 20:46:06 +03:00 by kerem · 6 comments

kerem commented

2026-03-07 20:46:06 +03:00

Owner

Originally created by @riccardomessineo on GitHub (May 11, 2022).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/820

Is your feature request related to a problem? Please describe.
Using Cloudbeaver with SQL Server, it seems dangerous to have system objects available to users.
I'm referring to system databases such as "master", "tempdb" and system schemas as "dbo", "INFORMATION_SCHEMA" and "sys".

Describe the solution you'd like
I'd like an option to enable or disable the system objects visibility in the connections

Originally created by @riccardomessineo on GitHub (May 11, 2022). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/820 **Is your feature request related to a problem? Please describe.** Using Cloudbeaver with SQL Server, it seems dangerous to have system objects available to users. I'm referring to system databases such as "master", "tempdb" and system schemas as "dbo", "INFORMATION_SCHEMA" and "sys". **Describe the solution you'd like** I'd like an option to enable or disable the system objects visibility in the connections

kerem

2026-03-07 20:46:06 +03:00

closed this issue
added the
xf:metadata editor

x:sql server
labels

kerem commented

2026-03-07 20:46:08 +03:00

Author

Owner

@riccardomessineo commented on GitHub (May 12, 2022):

If I am not mistaken, MS has an option to hide system objects on its SQL Server Management Studio:
https://docs.microsoft.com/en-us/sql/ssms/object/hide-system-objects-in-object-explorer?view=sql-server-ver15&viewFallbackFrom=sql-server-linux-2017

@riccardomessineo commented on GitHub (May 12, 2022): If I am not mistaken, MS has an option to hide system objects on its SQL Server Management Studio: https://docs.microsoft.com/en-us/sql/ssms/object/hide-system-objects-in-object-explorer?view=sql-server-ver15&viewFallbackFrom=sql-server-linux-2017

kerem commented

2026-03-07 20:46:08 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (May 12, 2022):

Thank you for your feature request. You can hide msdb database and INFORMATION_SCHEMA, sys schemas for now: disable Show system objects via the connection context menu in the Navigator tree.

@kseniiaguzeeva commented on GitHub (May 12, 2022): Thank you for your feature request. You can hide `msdb` database and `INFORMATION_SCHEMA`, `sys` schemas for now: disable **Show system objects** via the connection context menu in the Navigator tree. ![chrome_FcnlziFP5T](https://user-images.githubusercontent.com/51405061/168042991-5b696a7b-6574-4aa0-b1a2-2dc41d71597f.png)

kerem commented

2026-03-07 20:46:09 +03:00

Author

Owner

@riccardomessineo commented on GitHub (May 12, 2022):

Hello @kseniiaguzeeva ,
thanks for the support.

I tried the setting and tt hides "msdb" database, "information_schema" and "sys" schemas.
Is it "complete" though?
"master" and "tempdb" database and "dbo" schema are still displayed.

Setting on ("show system objects"):

Setting off ("hide system objects"):

@riccardomessineo commented on GitHub (May 12, 2022): Hello @kseniiaguzeeva , thanks for the support. I tried the setting and tt hides "msdb" database, "information_schema" and "sys" schemas. Is it "complete" though? "master" and "tempdb" database and "dbo" schema are still displayed. Setting on ("show system objects"): ![image](https://user-images.githubusercontent.com/10194398/168047687-73016979-0d42-4420-9416-425cf8e15c46.png) Setting off ("hide system objects"): ![image](https://user-images.githubusercontent.com/10194398/168047860-f6df8d84-b49a-4c05-b485-cec9752efd8d.png)

kerem commented

2026-03-07 20:46:10 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (May 12, 2022):

I'm discussing the feature request with CloudBeaver team and give you an answer what can be done.

@kseniiaguzeeva commented on GitHub (May 12, 2022): I'm discussing the feature request with CloudBeaver team and give you an answer what can be done.

kerem commented

2026-03-07 20:46:10 +03:00

Author

Owner

@serge-rider commented on GitHub (May 13, 2022):

Good point. Databases master, tempdb and model must be marked as system databases.

Schema dbo is not a system schema. It is a default schema and it is widely used as a container of user tables.

@serge-rider commented on GitHub (May 13, 2022): Good point. Databases `master`, `tempdb` and `model` must be marked as system databases. Schema `dbo` is not a system schema. It is a default schema and it is widely used as a container of user tables.

kerem commented

2026-03-07 20:46:10 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (May 23, 2022):

The improvement is available in the latest release 22.0.5.

@kseniiaguzeeva commented on GitHub (May 23, 2022): The improvement is available in the latest release 22.0.5.

kerem referenced this issue

2026-03-07 21:04:26 +03:00

[PR #203] [MERGED] Fix/overlapped titles #1525