数据库授权操作

  • A+
所属分类:Nginx
数据库授权操作

    mysql增加用户授权

        #登录mysql
        mysql -uUSER -pPASSWD
        #创建developer用户并且授权某表库所有表查询权限
        grant select on t-ietc.* to 'developer'@'%' identified by 'developer';
        grant select on *.* to 'developer'@'%' identified by 'developer';

    oracle增加用户授权
            su - oracle
            sqlplus admin/admin
            #创建用户
            #create user 密码 identified by 用户;
            create user developer identified by developer;
            alter user developer identified by developer;
            #为新增用户增加连接权限
            grant connect to developer;
            #给新增用户增加所有表读权限
            grant select  any table to developer;  
avatar

发表评论

您必须登录才能发表评论!