I've been trying to find guidance to set my OS permissions. What are the
minimum OS permission to allow a user to run SQL Enterprise Manager?
As far as I know, you don't need particular permissions at all to
run Enterprise Manager. Some functions may not be available to you
though, depending on your permissions in SQL Server.
Do you have any specific operation in mind?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Re: SQL CE Synching Problems ... I ran the wizard again to check all the permissions and this is what it ... [HTTP Content Folder Tab] ...Microsoft SQL Server 2000 Windows CE Edition ... (microsoft.public.sqlserver.ce)
Re: Permissions Issue ... If the problem is permissions, then enabling auditing should let you see the ... If the SQL client is running this application across the network using Named ... Pipes or Multi-Protocol to connect to the SQL server with SQL authentication... (microsoft.public.win2000.security)
Re: Help understanding Stored proc Level Secuirty? ... Second yes explains why you need to assign table permissions.... All permissions are checked when using dynamic sql.... Jasper Smith (SQL Server MVP)... I set permissions to my Stored Procedures,... (microsoft.public.sqlserver.security)
Re: SQL CE Synching Problems ... Have you granted IUSER_ServerName access to your publication within SQL... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ... (microsoft.public.sqlserver.ce)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
