Skip to content
Thursday, October 2, 2025

Ramblings of a Crafty DBA

  • Home
  • About John

Tag: ALTER USER

Crafting Databases – Part 2

August 22, 2011August 22, 2011 admin

The CREATE LOGIN and CREATE USER statements are part of the Data Definition Language (DDL) defined by Codd. Basically, a server login has to be defined so that person can connect to the server and a user login has to be created to map the server login to a particular database. I am going to continue my talk with the BSA hypothetical business problem from Part 1. Server logins allow access at the server level which can be defined using Windows Authentication or a SQL Server Authentication. Windows Authentication assumes…

Database DeveloperALTER LOGIN, ALTER USER, CREATE LOGIN, CREATE USER, database developer, DROP LOGIN, DROP USER, free code, John F. Miner III, SQL Server, TSQL2 Comments

Search Site

Categories

  • Database Admin (43)
  • Database Developer (81)
  • Fabric (6)
  • Other (39)
  • Power Query (4)
  • Presentations (66)
  • SQL Tidbits (101)

Archives

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Crafty Dba © 2024

Proudly powered by WordPress | Theme: AcmeBlog by Acme Themes