V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
0726
V2EX  ›  Oracle

问个有关 oracle 给用户赋权限的问题,大佬们帮忙看看

  •  
  •   0726 · Jan 24, 2021 · 1717 views
    This topic created in 1920 days ago, the information mentioned may be changed or developed.

    本人是后端开发,oracle 也只是了解一些.问的可能也不专业,大家见谅.

    现在公司让我新建一个用户 用于 SAP LT Replication Server hana 数据库来扒 oracle 的数据.
    

    官方文档的要求 一共有: • Select from the specific table • Create a table in the given schema (in order to successfully create the logging table) • Create sequence which can be used as a unique identifier in the logging table • Select from the logging table • Delete the logging table • Create database triggers for the specific table • Delete the database triggers • Create synonyms and views for the specific table • Delete the synonyms and the views

    我有个 dba 的账户 aa, 新建了一个账号:bb 上面的权限都给了后 测试 后台提示 “Failed to drop triggers for table”.

    请问 drop triggers 的权限怎么赋. 可以让 bb 操作 aa 下 新建的触发器.

    百度了一些都不好使..

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3134 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 41ms · UTC 14:15 · PVG 22:15 · LAX 07:15 · JFK 10:15
    ♥ Do have faith in what you're doing.