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 |
|
kiruthika
Yak Posting Veteran
67 Posts |
 Posted - 2008-09-02 : 02:51:25
|
| Dear friends, I'm using Sql 2005 with Windows authentication mode.I could not alter any tables or views or procedure etc.but before I've executed these statements. What permissions do i need to execute these statements? or what can i do to achieve my goal? Actually I'm not a DBA.Please help me. Thank You All!kiruthikahttp://www.ictned.eu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-02 : 03:24:39
|
To SP you need EXECUTE rights.For Tables and Views, you need SELECT rights.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-02 : 04:00:39
|
| Please speak with DBA and ask for providing you with rights for altering tables |
|
|
|
shanmp
Starting Member
13 Posts |
Posted - 2008-09-02 : 06:09:32
|
| You need to get the write access for the particular DB to perform alter/insert/drop/delete/truncate. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-02 : 09:45:47
|
| If its Production Server,then DBA should only have rights to alter table,Procedure,View. You need Alter permission for it. |
|
|
|
|
|
|
Can't alter table,procedure,view etc