How can we map the user to named schema

• hidayath

  Right there with Babe

  Points: 730

  More actions

  January 24, 2019 at 10:05 am

  #379122

  How can we map the user to named schema and without giving the schmea.tablename how can we access the user directly in named schmea
  Eg: select * from table1 (in named schema ) can we access directly.

  Thanks in advance .

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  January 24, 2019 at 10:46 am

  #2020011

  In each database, for each user you can assign them a default schema:
  https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-user-transact-sql?view=sql-server-2017
  however, if there is the potential for the same table or view name to exist in multiple schemas, then any queries written with just a table name as you describe would not be portable to other users.