Does anyone know how to block a developer from editing object through
enterprise manager, without uninstalling it from their machines?

I am trying to use the new schema model on SQL 2005 to control permissions
for users on my database.
I have two users on my database (User1 and User2) and a schema called
TestSchema.

Is there a way to keep the windows users off from the sql databases. My
problem is all our lanwan people are admin on the server and they go in any
database and can do whatever they want. How can I keep them out.
I just want the databases to be access by sql users only.

Environment:
Window2K workstation, SQL Server 2000 Vesion 8.00.760 (SP3)
Setup:
I have a database setup so that NO users (except dbo) have READ,

I am trying to add a Data view to a sharepoint site. When I try to create a
connection to the SQL database I get an Authentication error.
I have tried both the Windows Authentication and a Username. I am a DB
administrator and have full access to the database and its server.

Some hacker has set off a program to try and guess the sa password to my SQL
Server that is public (1433 is open) -- I'm logging all the attempts (about
6 a minute from the start of my logging til now -- several 100,000
combinations and counting.

After I create a user (ref to database), then I need to assign 'select' &
'exec' rights at permissions for all objects. But there are over 1000
objects. How can I set the permissions quickly? Can I do it at query
analyzer?

Hi,
I am stall having a problem with access is denied running a simple
exec xp_cmdshell 'dir \\othercomputer\cshare\'. I have setup my
SQL agent and proxy account to a account called SQIUSER and gave

I would like to know if there is a way to get a password protected table in
sqlserver 2000, developer EDITION
The database administrator can open any table including a user table  and he
can know the password of any user just by opening the table,   that's why is

I am assigning security rights for some login ids. I would like to know if I
allow some users to manage their jobs in SQL Server Agent themselves, but I
don't want to give them "Server Administrators" role in Server Roles. Which
Server Role should I assign to the users?

I was trying to enable non-sysadmin account to exec xp_cmdshell through the
setup of the SQL Agent proxy account in SQL Server Agent --> Properties -->
Job system; however I got an message said:  Unable to set the SQL Agent proxy
account because of the reason listed below. 'Error ...

When I execute the following for a fixed database role:
EXEC sp_dbfixedrolepermission 'db_denydatawriter'
the resultset is as follows:
db_denydatawriter No DELETE permission on any object

using SqlServer 2K
I want to create a linked server to another SQL SERVER 2K box, but I do not
want to use the actual server name as @server as this is dev and I have no
idea what the final server name will be.  I would prefer to use an alias thus

If connecting to a database with Query Analyser or Enterprise Manager using
Sql-authentication, is the login information sent over the network in clear
text?
Regards,

I have granted SELECT permissions on a view to a user, now when I run the
view it tells me that the user is denied select permissions on a table.  The
user does not have any other permissions set on any tables or views other
than the SELECT on this particular view.  How can I allow ...