Hi,

1. use sp_password '<oldpasswor>','newpassword','<username>'
eg. sp_password 'xyz','abc','sa' -- xyz -- old password, abc-- newpassword.

2. you have to use sp_addlogin, sp_addrolemember or GRANT command. Please
check Book Online for help.

3. Use profiler under start-microsoft sql server.

Thanks,
KM


----- Original Message -----
From: " M B Shibu" <basher.[Email Address Removed] <[Email Address Removed] Tuesday, May 21, 2002 3:21 PM
Subject: some simple questions


Hi all

I am new to sqlserver and is confused with many things in sqlserver
i have few doubhts . Please help me to solve this

1) I want to alter the password of the user sa
2) i want to create some new users and give them persmission
such that they can only insert, update , and select .No create , alter
and drop

3) how to do auditing in sqlserver


Please help me in solving this . In my database many people are playing and
i am trying to restrict it.This is urgent .


regards,
shibu

MS Sql Server LazyDBA home page