Le Kevin dot com

photographic-poetic-musical horizon

Browsing Posts tagged change

Change folder and subfolders Recursively change the permission $ chmod -R 0777 * $ chmod -R 0777 /home/user/demo Change files A. To change file access permissions you use chmod command. It has -R or -recursive option that change files and directories recursively. For example $ chmod -R 0755 directory However, if you need to apply [...]

Sometime as a database developer, we might come across changing the schema for the whole database This is one way to do it; by generating multiple queries in the query editor: SELECT ‘EXEC(”sp_changeobjectowner @objname = ””oldDBO.’ + name +’ ”” , @newowner = dbo”) ‘ FROM sys.tables WHERE schema_id = SCHEMA_ID(‘oldDBO’); Also below is the [...]