Re: SQL2000 UserPermissions for Database

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: Finding total used space
    ... If you run sp_helpfile against each database you will get a report. ... exec sp_helpfile 'master' ... the file space for a database is actually used. ... > Is there a table somewhere in master or somewhere, ...
    (microsoft.public.sqlserver.security)
  • Re: New install of Windows 2003 EE sp1 and Sql Server 2000 sp3 full text problem
    ... i'm the database guy and I didn't alter it. ... default db is master and it belongs to the ... > database with sysadmin rights? ... > exec sp_defaultdb N'NT Authority\System', ...
    (microsoft.public.sqlserver.fulltext)
  • Error 21776:
    ... use master ... exec sp_addsrvrolemember 'DOMAIN\ug_ITSec_SQL', 'securityadmin' ... However, when I then click on the Login and check out the database access, I ...
    (microsoft.public.sqlserver.security)
  • Re: Error 21776:
    ... use master ... exec sp_addsrvrolemember 'DOMAIN\ug_ITSec_SQL', 'securityadmin' ... Then after, trying to grant that new login db_owner permissions, for ... However, when I then click on the Login and check out the database access, ...
    (microsoft.public.sqlserver.security)
  • 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)