HOw can I prevent a user to see all dBs in SQL server thru enterprise manager even he has rights only on 1 db.
360549
in enterprise manager, if you select security, and then logings, and find your users or group, then double click on them, and you should find the security settings.\n\ngenerally if you set up your rights, you can see the db but wont be able to do anything with it
158614
Create a user account with administrator privileges (add this account to the Administrators group). Than go to My Computer, right click on drive F: and select the Properties menu and the Security tab. In the upper window select the user just created and uncheck its all rights in the window below.
595600
no, yo can have them all be adminisrtator accouts if you wish, there is an overall admin accout you don't see unless yo boot in safe mode.
541709
give them all user accounts and then only give them priviliges of guest\n\nthats wat i do in windows should work sam anyway gl trying
1030118
Go to administrative tools then to services disable remote access
152395
try log in again, you might not be able to view certain files because of your user rights. your administrator is the one that controls what one see and does so talk to him/her.
617649
It is simple friend. Just purchase and install winguardpro. It is a security software that is userfriendly and excellent. U can lock the whole hard disk and prevent anyone else to view its content. I use the same :-)
116643
This isn't something you can do going backwards, but if you are running a Windows server you can do auditing. To turn auditing on you will need to set your local policy to do so.
764205
user accounts in control panel
223098
Your sysadmin person will probably have to recreate your account.  next time secure it with one of those annoying strong passwords.
989238
Hi,\n\nFor that situation it would be really absurd to do this. Remember Todays relational databases have no limitation on size, so unless your records are billions in length, you don't need to worry about the size of your table.\n\nIt is better to have a User table and all users will be within it.  Don't worry people are running tables with the proper optimization that have billions of rows ~terabytes of data!\n\nBut back to your question:\nALTER SCHEMA dbo TRANSFER Schema.TableName\n\nI think that is your query...\n\nsp_changeobjectowner doesn't work actually in SqlServer 2005. You have to use ALTER SCHEMA.\n\nfrom BOL:\nALTER SCHEMA schema_name TRANSFER securable_name
693751
1. Secure the server. protect it from physical damage. limit access to the server.\n2. Database Connections: use trusted ip. only answer predefined addresses. all connections should be uniquely identified and controlled.\n3. Table Access Control. reads should be read-only. writes access should be limited to the tables necessary to accomplish the tasks\n4. Restricting Database Access: protect ports that are open on the network.
928031
Check the path in the connection string.  Make sure that if it says "c:&#92;whaterver&#92;whaterver&#92;blah.mdb" that the path is the same on the server.\n\nAlso, check IIS settings and file system privileges to make sure that .NET has permission to access the databse.  Go to IIS, right click on the folder for the app.  Make sure it is configured as an application.  Also, make sure that read access is granted.\n\nIn Windows Explorer, right click on the folder where the database is and choose properties.  Click on th esecurity tab and ensure that the internet gues account has access to the folder.
629512
You can apply ACL permissions at the file level with active directory permissions to prevent an executible from being ran.\n\nIf you want to restrict a user from logging into that machine just add the machines that the user can log into in that account setup under AD.\n\nOther than that more clarification is required
685690
the netwrok server keeps a record of all transactions on a program.  that program is as easily accessed as microsoft windows.  yahoo answers would most likely show up as just that, yahoo answers.  i would assume that this isn't a huge problem until you are wasting so much of your work time.  during certain times of the year, fantasy football and march madness especially, it is estimated that billions of dollars are lost by businesses due to this type of activity by employees.  you should know your company's policies and follow them if you like your job
411560
Well you need to bring your boss, and let him see when he does it. On the other hand, every action that is taken by the Network Administrator or Local users are recorded in Event Viewer in the Computer Manager(Right click My Computer and select Manage). Keep a copy of the Event manager, as the administrator may delete that too, and review them right after you see something wrong or unexpected in your workstation.\n\nIf your network administrator as restricted to you to open the Computer Manager or the the event viewer, the I guess you need to lodge a formal complain to your boss, because there is no other way. Even if there is, you dont want to use them, because your network adminitrator may charge against you as they ARE illegal to use in the controlled network with out permission.
1005391
you can use \nSecurity Administrator \nand close anything you want for certain users !!!\nits very easy