You need to create a new login account for one of your Unix users named WoodsJ. Which command would you use to do this?

You need to create a new login account for one of your Unix users named WoodsJ. Which command would you use to do this?

You need to create a new login account for one of your Unix users named WoodsJ. Which command would you use to do this?


Answer: -  sp_addlogin ‘WoodsJ’, ‘Pa$$w0rd’, ‘AdventureWorks’

(Because this is a Unix user, you know the user does not have a Windows account against which to be verified. You must use sp_addlogin as opposed to sp_grantlogin, which is used only for mapping to Windows accounts. The other two stored procedures do not exist.)