Re: Viewing default db role permissions

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 04/27/05 

Date: Tue, 26 Apr 2005 19:46:18 -0500

> Is there a stored procedure I can call that will show me that data?

sp_dbfixedrolepermission will list permissions assigned to a fixed database
role. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"headware" <dkland@cox.net> wrote in message 
news:1114530123.724903.28710@g14g2000cwa.googlegroups.com...
> If you can't view them through Enterprise Manager is there another way?
> Is there a stored procedure I can call that will show me that data?
>

Relevant Pages

  • Re: SQL Server returning Empty Fields and there should be data
    ... 2K (Win2K Server Machine), I use a Stored Procedure to handle getting the ... For example, in the two lines above, the Project Input box would ... to open the SP in Enterprise Manager or MS Access, ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL Server 2005 - Cant edit results from stored procedure
    ... > then run a stored procedure that returned data from a 2 table select ... > statement and edit the data. ... I don't use Enterprise Manager much but I'd be surprised if it's possible to ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: DTSRun from SP
    ... To create a job and schedule the stored procedure in ... Enterprise Manager, go to Management, SQL Server Agent and ... Create a T-SQL job step to execute the stored procedure. ... >where do i look for the job or the code in enterprise manager ...
    (microsoft.public.sqlserver.dts)
  • Re: stored procedures in vb6 und sql server
    ... > eigener benutzeroberfläche anmeldepasswörter am sql-server ändern zu können ... > selbstständig ohne enterprise manager ändern können). ... die stored procedure wird am besten mit dem Enterprise Manager ...
    (microsoft.public.de.sqlserver)
  • Re: output parameter T-sql doesnt work
    ... out-of-range smalldatetime value. ... Stored Procedure: Asset.dbo.prStoreOrder ... I've literally copied the insert into statement from enterprise manager, ... The message about char data to smalldatetime sounds ...
    (microsoft.public.sqlserver.server)