I have a user in Oracle for which the permissions given are CONNECT and SELECT_CATALOG_ROLE.
How do you find the equivalents when setting up a similar user in SQL Server?
Sql-server – How to find equivalent of Oracle’s privileges in SQL Server
oraclesql server
Related Question
- SQL Server – Service Account Windows Privileges and Rights
- Oracle 11g R2 – Permissions Needed for dbms_metadata.get_ddl in a Function
- SQL Server Permissions – Resolving Confused Logins and Users
- Oracle 12c – How to Configure SQL Developer
- SQL Server – Analyze, Vacuum Equivalent?
- SQL Server – Oracle 12c (RDS) Questions from a SQL Server DBA
- Oracle – Equivalent Idioms in Google BigQuery
Best Answer
In SQL Server the right to "CONNECT" is given at the instance level. You'll find this right assigned to the login. The ability to view the database catalog is given at the database level by assigning the "VIEW DEFINITION" right to the database or the schema.