Re: SQL2000 UserPermissions for Database

logged in as userx

exec usp_ListDatabasesForLogin return

EXECUTE permission denied on object 'usp_ListDatabasesForLogin',
database 'databaseA', owner 'dbo'.

As with any stored procedure, the invoking user needs execute permissions, either directly or via role membership. Try:

GRANT EXEC ON dbo.usp_ListDatabasesForLogin TO userx

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Arejan" <areejan2000@xxxxxxxxx> wrote in message news:1165609013.358290.126580@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
logged in as userx

exec usp_ListDatabasesForLogin return

EXECUTE permission denied on object 'usp_ListDatabasesForLogin',
database 'databaseA', owner 'dbo'.

but sa(admin) can


meanwhile i have created Newsp_helplogins under master and this will
update the

new_userdb_Table with dbname and user (#tb2_PlainLogins is removed)


but then userx cannot exec this too.


how do i set permission to run and "not to create" a sp for a user ?

or call a trigger that will run the sp as sa(admin) or if possible
any user and retrive data from the table.


.

Relevant Pages

  • Re: Stored procedure to drop and create table for end user
    ... which has a user called benetest with the password ... which has execute permission on when i execute BENESP_TEST like ... exec BENESP_TEST 'test' ... depending on the database... ...
    (microsoft.public.sqlserver.programming)
  • Re: DBO user missing in two databases
    ... Jasper Smith wrote: ... > To change the owner of the databases simply use sp_changedbowner e.g. ... > exec sp_changedbowner 'sa','true' ... There is a small and totally insignificant danger in using sa as a database ...
    (microsoft.public.sqlserver.security)
  • RE: Transfering Database Ownership
    ... I take it you mean he is the owner of the database? ... EXEC sp_changedbowner 'sa' ... > wondering how to transfer the ownership of the database to ...
    (microsoft.public.sqlserver.server)
  • Re: Cant get global config data and KB 900499 doesnt help
    ... The account you use to create the database MUST have the following rights on ... DECLARE @AdminVSAccount nvarchar ... DECLARE @ContentVSAccount nvarchar ... EXEC sp_grantlogin @ContentVSAccount; ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Permission in database
    ... You can create database roles and assign object permissions to these ... EXEC sp_addrole 'Administrators' ... GRANT SELECT, INSERT, UPDATE, DELETE ON Sales TO Administrators ...
    (microsoft.public.sqlserver.security)