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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-12 : 07:30:37
|
| V. Hari Krishnan writes "Hi Everybody,I have two Databases in a Server, Namely PMS and QualityInn.When i'm inserting a record from fornt-end to one of the tablesin the PMS Database, I want the same data to be inserted intoa table in QualityInn Database. For which purpose I've written atrigger on a table in PMS Database. But I get the following Error:-Run Time Error 4000242000[Microsoft][ODBC SQL Server Driver][SQL Server]Select Permission denied on object 'SRMSequences' database'QualityInn', owner 'dbo'Table Name:SRMSequences in QualityInn Database.Tablw Owner:dbo.Kinldy let me know how to resolve this problem. I've tried changing permission to the table, but could'nt resolve.Your help in this regard is anticipated...Regards,Hari V" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-12 : 17:31:28
|
| What permissions did you change on the table? The user needs SELECT permission on SRMSequences in the QualityInn database. The user that needs the permissions would be the one that your application is using. So add the SELECT permission to this user for that table. If the user doesn't exist in the QualityInn database, then add it and then assign the permission.Tara |
 |
|
|
|
|
|
Database Triggers