Hi,
I'm using SQL Prompt 10.16.12 as normal SQL-user on SQL Server 2019. The user has only rights public, data_reader and data_writer on the current database.
Not any special permission on the server, and could only see his database, master and tempdb. BUT can select information_schema.*, sys.tables, sys.columns and so on, on current database.
Intellisense does not show any field of the current database. What right is missing?
Thanks a lot,
Magnus
Hi,
I'm using SQL Prompt 10.16.12 as normal SQL-user on SQL Server 2019. The user has only rights public, data_reader and data_writer on the current database.
Not any special permission on the server, and could only see his database, master and tempdb. BUT can select information_schema.*, sys.tables, sys.columns and so on, on current database.
Intellisense does not show any field of the current database. What right is missing?
Thanks a lot,
Magnus