Kannan:

Thanks for ur reply .

regards,
shibu


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


> 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] To: <[Email Address Removed] Sent: 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
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page