Sql Enterprise Manager
-
How can i hide a database to be listed in sql enterprise manager else how can i prevent data from being deleted in a table through enterprise manager
Make sure only authorized users have rights to make changes to the database. If users have access to their own SQL user names and passwords for an application then you can't prevent them from using other access tools.
I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon
-
How can i hide a database to be listed in sql enterprise manager else how can i prevent data from being deleted in a table through enterprise manager
smita_roy wrote: How can i hide a database to be listed in sql enterprise manager => No u cannot hide ur DB in SQL Enterprise Manager, I think. Because this GUI used to manage Databases smita_roy wrote: how can i prevent data from being deleted in a table through enterprise manager => u need to ensure that there's no one knows ur DB password except u << >>
-
How can i hide a database to be listed in sql enterprise manager else how can i prevent data from being deleted in a table through enterprise manager
(1) How can i hide a database to be listed in sql enterprise manager ? Just Detach the Database in the Enterprise Manager. (2) How can i prevent data from being deleted in a table through enterprise manager ? Remove the permission from the user REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} FROM user [, user] ... REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...