Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TAS
Yak Posting Veteran
65 Posts |
 Posted - 2005-07-11 : 14:13:30
|
| Is there any way to let user (not administrator) to create their own tables? |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-11 : 14:22:38
|
| GRANT CREATE TABLE TO DangerousDeveloperThat being said, do not do this. Recipe for disaster. It is rarely a good idea to create permananent database objects on the fly and creating tables on the fly is usually indicative of a design problem that will eventually not scale.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
|
|
|
How to let user to create their own table?