Sp_addrolemember
Jan 17, 2001
Dear All colleaques
Can any one tell me why I can not see Loc_ecomdev_des as a server user or a db user when viewing through EM, after executing this script.
EXEC sp_grantdbaccess 'ecomdevloc_ecomdev_des, 'loc_ecomdev_des'
GO
EXEC sp_addrolemember 'db_securityadmin', 'loc_ECOMDEV_des'
I can only see loc_ecomdev_des as a member of the db_securityadmin when I view properties of db_securityadmin role in that database.
Also what can I run in QA to display db_securityadmin members.
Saad
View 1 Replies
Dec 27, 2006
how to try-catch sp_addrolemember?
View 4 Replies
View Related
Mar 22, 2007
When I login localy (computer with sql server) I can call procedure sp_addrolemember but when I am loged in remotely (from client computer)and try to call the same procedure I get this message: 'User does not have permission to performe this action'.
View 1 Replies
View Related
Mar 27, 2006
I'm trying to handle some user management inside a trigger. When I call sp_addrolemember I get this error.
sp_addrolemember cannot be used inside a user-defined transaction
Is there any way to get around this error? I need to assign a custom role based on a variable inside this trigger.
Any help is appreciated.
View 5 Replies
View Related
Jul 9, 2007
I use sp_addrolemember inside a DML trigger and every thing goes well in my computer; I can insert or update into my table and sp_addrolemember is executed successfully, but my customer get this error every time he tries to insert or update into the table.
"the procedure 'sp_addrolemember' cannot be executed within a transaction"
Can anybody help me solve this funny error.
View 1 Replies
View Related
Jul 20, 2005
Hi,Is there any way that calls to sp_addrolemember and sp_droprolemembercan be enabled for non database owners and non sysadmin members?This would be very helpful for an application I'm in the middle ofdeveloping, in which users have the right to view some data and editsome data in a set of tables. The data is pulled up in a set of views(using SQL Server 7 with an Access 2000 front-end). Depending on aninitial selection that the user makes, s/he should be able to eitherread or edit the data.The solution I hoped to use would run a stored procedure, that amongstother things would add and/or remove the user to/from a data_read anddata_edit role, depending on the initial selection s/he made.Any suggestions?Much thanks!Oren Bergman
View 3 Replies
View Related
