|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
July 16th, 2003, 07:13 PM
|
|||
|
|||
|
A little SQL 2000 help
Hello everyone. I am basically a major novice at SQL 2000 and need a little assistance. I created a new login and want to give this login all access except delete permissions to a database. What is the best way to do this? In query analyzer, I tried GRANT SELECT, INSERT, UPDATE, but can only get one table at a time in the DB to work. Any suggestions?
|
|
#2
July 17th, 2003, 04:35 PM
|
|||
|
|||
Well first you log on as SA(system administrator) on your database throught SQL Server Enterprise Manager. Once you expand your database tree you should see a area called "Users" In there you can set permission level for users. But rememeber only logging in as the User that created the database can be able to give permission to the other User, unless you are SA.
Good luck
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > A little SQL 2000 help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
