General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Correct implementation of sp_setapprole
Sigh, it's been a busy day for me on UT...
I've altered my application's connection scheme to connect to the SQL 2005 DB as a restricted user, and then issue the sp_setapprole command to gain insert/update/delete/select rights.
I'm able to select data fine into remote views, and cursors through SPT, but when it comes to update data, (RVs or EXEC commands), the DB throws up and tells me :
"[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "dbo.tablename" because it does not exist or you do not have permissions."
My application role (name=role) has the following granted to it (database=x)(TSQL statments):
use [x]
GO
GRANT DELETE TO [role]
GO
use [x]
GO
GRANT EXECUTE TO [role]
GO
use [x]
GO
GRANT INSERT TO [role]
GO
use [x]
GO
GRANT SELECT TO [role]
GO
use [x]
GO
GRANT UPDATE TO [role]
GO
Is this the correct way to grant the kind of rights I want to the application role?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only